Terima kasih sebelumnya, untuk tantangannya, sebelumnya format data sudah
tersusun seperti yang Mr. Kid gambarkan, hanya saja, ketika ada additive baru,
maka yg sering saya lakukan adalah meng-insert row untuk mengurutkan datanya,
Tantangan selanjutnya adalah, saya ingin agar pengeditan berjalan seperti yang
pernah Mr. Kid bahas disini sehingga fleksibiltasnya tinggi...
SalamHaris
On Thursday, April 2, 2015 10:32 AM, "'Mr. Kid' [email protected]
[belajar-excel]" <[email protected]> wrote:
oh iya,
gak keangkut ternyata.
moga-moga yang ini bisa.
hehehe
sorry ya
On Thu, Apr 2, 2015 at 2:13 PM, ris ha [email protected] [belajar-excel]
<[email protected]> wrote:
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
#yiv8533038914 #yiv8533038914 -- #yiv8533038914ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8533038914
#yiv8533038914ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8533038914
#yiv8533038914ygrp-mkp #yiv8533038914hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv8533038914 #yiv8533038914ygrp-mkp #yiv8533038914ads
{margin-bottom:10px;}#yiv8533038914 #yiv8533038914ygrp-mkp .yiv8533038914ad
{padding:0 0;}#yiv8533038914 #yiv8533038914ygrp-mkp .yiv8533038914ad p
{margin:0;}#yiv8533038914 #yiv8533038914ygrp-mkp .yiv8533038914ad a
{color:#0000ff;text-decoration:none;}#yiv8533038914 #yiv8533038914ygrp-sponsor
#yiv8533038914ygrp-lc {font-family:Arial;}#yiv8533038914
#yiv8533038914ygrp-sponsor #yiv8533038914ygrp-lc #yiv8533038914hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8533038914
#yiv8533038914ygrp-sponsor #yiv8533038914ygrp-lc .yiv8533038914ad
{margin-bottom:10px;padding:0 0;}#yiv8533038914 #yiv8533038914actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8533038914
#yiv8533038914activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8533038914
#yiv8533038914activity span {font-weight:700;}#yiv8533038914
#yiv8533038914activity span:first-child
{text-transform:uppercase;}#yiv8533038914 #yiv8533038914activity span a
{color:#5085b6;text-decoration:none;}#yiv8533038914 #yiv8533038914activity span
span {color:#ff7900;}#yiv8533038914 #yiv8533038914activity span
.yiv8533038914underline {text-decoration:underline;}#yiv8533038914
.yiv8533038914attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv8533038914 .yiv8533038914attach div a
{text-decoration:none;}#yiv8533038914 .yiv8533038914attach img
{border:none;padding-right:5px;}#yiv8533038914 .yiv8533038914attach label
{display:block;margin-bottom:5px;}#yiv8533038914 .yiv8533038914attach label a
{text-decoration:none;}#yiv8533038914 blockquote {margin:0 0 0
4px;}#yiv8533038914 .yiv8533038914bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv8533038914
.yiv8533038914bold a {text-decoration:none;}#yiv8533038914 dd.yiv8533038914last
p a {font-family:Verdana;font-weight:700;}#yiv8533038914 dd.yiv8533038914last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8533038914
dd.yiv8533038914last p span.yiv8533038914yshortcuts
{margin-right:0;}#yiv8533038914 div.yiv8533038914attach-table div div a
{text-decoration:none;}#yiv8533038914 div.yiv8533038914attach-table
{width:400px;}#yiv8533038914 div.yiv8533038914file-title a, #yiv8533038914
div.yiv8533038914file-title a:active, #yiv8533038914
div.yiv8533038914file-title a:hover, #yiv8533038914 div.yiv8533038914file-title
a:visited {text-decoration:none;}#yiv8533038914 div.yiv8533038914photo-title a,
#yiv8533038914 div.yiv8533038914photo-title a:active, #yiv8533038914
div.yiv8533038914photo-title a:hover, #yiv8533038914
div.yiv8533038914photo-title a:visited {text-decoration:none;}#yiv8533038914
div#yiv8533038914ygrp-mlmsg #yiv8533038914ygrp-msg p a
span.yiv8533038914yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8533038914
.yiv8533038914green {color:#628c2a;}#yiv8533038914 .yiv8533038914MsoNormal
{margin:0 0 0 0;}#yiv8533038914 o {font-size:0;}#yiv8533038914
#yiv8533038914photos div {float:left;width:72px;}#yiv8533038914
#yiv8533038914photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv8533038914
#yiv8533038914photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8533038914
#yiv8533038914reco-category {font-size:77%;}#yiv8533038914
#yiv8533038914reco-desc {font-size:77%;}#yiv8533038914 .yiv8533038914replbq
{margin:4px;}#yiv8533038914 #yiv8533038914ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv8533038914 #yiv8533038914ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8533038914
#yiv8533038914ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8533038914
#yiv8533038914ygrp-mlmsg select, #yiv8533038914 input, #yiv8533038914 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv8533038914
#yiv8533038914ygrp-mlmsg pre, #yiv8533038914 code {font:115%
monospace;}#yiv8533038914 #yiv8533038914ygrp-mlmsg *
{line-height:1.22em;}#yiv8533038914 #yiv8533038914ygrp-mlmsg #yiv8533038914logo
{padding-bottom:10px;}#yiv8533038914 #yiv8533038914ygrp-msg p a
{font-family:Verdana;}#yiv8533038914 #yiv8533038914ygrp-msg
p#yiv8533038914attach-count span {color:#1E66AE;font-weight:700;}#yiv8533038914
#yiv8533038914ygrp-reco #yiv8533038914reco-head
{color:#ff7900;font-weight:700;}#yiv8533038914 #yiv8533038914ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv8533038914 #yiv8533038914ygrp-sponsor
#yiv8533038914ov li a {font-size:130%;text-decoration:none;}#yiv8533038914
#yiv8533038914ygrp-sponsor #yiv8533038914ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv8533038914
#yiv8533038914ygrp-sponsor #yiv8533038914ov ul {margin:0;padding:0 0 0
8px;}#yiv8533038914 #yiv8533038914ygrp-text
{font-family:Georgia;}#yiv8533038914 #yiv8533038914ygrp-text p {margin:0 0 1em
0;}#yiv8533038914 #yiv8533038914ygrp-text tt {font-size:120%;}#yiv8533038914
#yiv8533038914ygrp-vital ul li:last-child {border-right:none
!important;}#yiv8533038914