Maaf Mr. Kid, file terlampirnya kok g ada, apa tertinggal lupa belum 
dilampirkan...
SalamHaris
 


     On Wednesday, April 1, 2015 7:02 AM, "'Mr. Kid' [email protected] 
[belajar-excel]" <[email protected]> wrote:
   

     Wa'alaikumussalam wr wb

Pada sheet myData di file terlampir adalah sekedar contoh.

Wassalamu'alaikum wr wb
Kid.


2015-03-24 18:07 GMT+11:00 ris ha [email protected] [belajar-excel] 
<[email protected]>:

     Assalamu'alaikum.
Mohon bantuannya rekan2 master excel semua.Seharian ini, saya utak atik pivot, 
tapi hasilnya belum sesuai dengan yang diharapkan (file terlampir).Saya ingin 
Data Blank hilang pada pivot, namun tampaknya memang tidak bisa hilang.
Bagaimana ya caranya...???
Makasih sebelumnya atas pencerahan para master excel semua.
SalamHaris
   

  #yiv0464778391 #yiv0464778391 -- #yiv0464778391ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0464778391 
#yiv0464778391ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0464778391 
#yiv0464778391ygrp-mkp #yiv0464778391hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv0464778391 #yiv0464778391ygrp-mkp #yiv0464778391ads 
{margin-bottom:10px;}#yiv0464778391 #yiv0464778391ygrp-mkp .yiv0464778391ad 
{padding:0 0;}#yiv0464778391 #yiv0464778391ygrp-mkp .yiv0464778391ad p 
{margin:0;}#yiv0464778391 #yiv0464778391ygrp-mkp .yiv0464778391ad a 
{color:#0000ff;text-decoration:none;}#yiv0464778391 #yiv0464778391ygrp-sponsor 
#yiv0464778391ygrp-lc {font-family:Arial;}#yiv0464778391 
#yiv0464778391ygrp-sponsor #yiv0464778391ygrp-lc #yiv0464778391hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0464778391 
#yiv0464778391ygrp-sponsor #yiv0464778391ygrp-lc .yiv0464778391ad 
{margin-bottom:10px;padding:0 0;}#yiv0464778391 #yiv0464778391actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0464778391 
#yiv0464778391activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0464778391
 #yiv0464778391activity span {font-weight:700;}#yiv0464778391 
#yiv0464778391activity span:first-child 
{text-transform:uppercase;}#yiv0464778391 #yiv0464778391activity span a 
{color:#5085b6;text-decoration:none;}#yiv0464778391 #yiv0464778391activity span 
span {color:#ff7900;}#yiv0464778391 #yiv0464778391activity span 
.yiv0464778391underline {text-decoration:underline;}#yiv0464778391 
.yiv0464778391attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv0464778391 .yiv0464778391attach div a 
{text-decoration:none;}#yiv0464778391 .yiv0464778391attach img 
{border:none;padding-right:5px;}#yiv0464778391 .yiv0464778391attach label 
{display:block;margin-bottom:5px;}#yiv0464778391 .yiv0464778391attach label a 
{text-decoration:none;}#yiv0464778391 blockquote {margin:0 0 0 
4px;}#yiv0464778391 .yiv0464778391bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv0464778391 
.yiv0464778391bold a {text-decoration:none;}#yiv0464778391 dd.yiv0464778391last 
p a {font-family:Verdana;font-weight:700;}#yiv0464778391 dd.yiv0464778391last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0464778391 
dd.yiv0464778391last p span.yiv0464778391yshortcuts 
{margin-right:0;}#yiv0464778391 div.yiv0464778391attach-table div div a 
{text-decoration:none;}#yiv0464778391 div.yiv0464778391attach-table 
{width:400px;}#yiv0464778391 div.yiv0464778391file-title a, #yiv0464778391 
div.yiv0464778391file-title a:active, #yiv0464778391 
div.yiv0464778391file-title a:hover, #yiv0464778391 div.yiv0464778391file-title 
a:visited {text-decoration:none;}#yiv0464778391 div.yiv0464778391photo-title a, 
#yiv0464778391 div.yiv0464778391photo-title a:active, #yiv0464778391 
div.yiv0464778391photo-title a:hover, #yiv0464778391 
div.yiv0464778391photo-title a:visited {text-decoration:none;}#yiv0464778391 
div#yiv0464778391ygrp-mlmsg #yiv0464778391ygrp-msg p a 
span.yiv0464778391yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0464778391 
.yiv0464778391green {color:#628c2a;}#yiv0464778391 .yiv0464778391MsoNormal 
{margin:0 0 0 0;}#yiv0464778391 o {font-size:0;}#yiv0464778391 
#yiv0464778391photos div {float:left;width:72px;}#yiv0464778391 
#yiv0464778391photos div div {border:1px solid 
#666666;height:62px;overflow:hidden;width:62px;}#yiv0464778391 
#yiv0464778391photos div label 
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0464778391
 #yiv0464778391reco-category {font-size:77%;}#yiv0464778391 
#yiv0464778391reco-desc {font-size:77%;}#yiv0464778391 .yiv0464778391replbq 
{margin:4px;}#yiv0464778391 #yiv0464778391ygrp-actbar div a:first-child 
{margin-right:2px;padding-right:5px;}#yiv0464778391 #yiv0464778391ygrp-mlmsg 
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0464778391 
#yiv0464778391ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0464778391 
#yiv0464778391ygrp-mlmsg select, #yiv0464778391 input, #yiv0464778391 textarea 
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv0464778391 
#yiv0464778391ygrp-mlmsg pre, #yiv0464778391 code {font:115% 
monospace;}#yiv0464778391 #yiv0464778391ygrp-mlmsg * 
{line-height:1.22em;}#yiv0464778391 #yiv0464778391ygrp-mlmsg #yiv0464778391logo 
{padding-bottom:10px;}#yiv0464778391 #yiv0464778391ygrp-msg p a 
{font-family:Verdana;}#yiv0464778391 #yiv0464778391ygrp-msg 
p#yiv0464778391attach-count span {color:#1E66AE;font-weight:700;}#yiv0464778391 
#yiv0464778391ygrp-reco #yiv0464778391reco-head 
{color:#ff7900;font-weight:700;}#yiv0464778391 #yiv0464778391ygrp-reco 
{margin-bottom:20px;padding:0px;}#yiv0464778391 #yiv0464778391ygrp-sponsor 
#yiv0464778391ov li a {font-size:130%;text-decoration:none;}#yiv0464778391 
#yiv0464778391ygrp-sponsor #yiv0464778391ov li 
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv0464778391 
#yiv0464778391ygrp-sponsor #yiv0464778391ov ul {margin:0;padding:0 0 0 
8px;}#yiv0464778391 #yiv0464778391ygrp-text 
{font-family:Georgia;}#yiv0464778391 #yiv0464778391ygrp-text p {margin:0 0 1em 
0;}#yiv0464778391 #yiv0464778391ygrp-text tt {font-size:120%;}#yiv0464778391 
#yiv0464778391ygrp-vital ul li:last-child {border-right:none 
!important;}#yiv0464778391 

  

Kirim email ke