Terima kasih Mr. Kid. Salam,HK Sent from Yahoo Mail on Android On Tue, May 15, 2018 at 5:40, 'Mr. Kid' mr.nm...@gmail.com [belajar-excel]<belajar-excel@yahoogroups.com> wrote:
Pak HK, Pada field yang diletakkan pada sisi Column di set agar Show item with no data. Regards,Kid 2018-05-14 15:33 GMT+07:00 hendrik karnadi hendrikkarn...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com>: Dear BeExcel, khususnya pemerhati PivotTable.. Saya mengalami sedikit permasalahan dengan Perubahan Tampilan PivotTable yang saya belum dapat solusinya (saya pakai Excel 2013 dan 2016) dan perlu bantuan pakar PivotTable. Terlampir ada dua file:- File Sumber Stock_PL(R) yang terdiri dari Sheets Stock (Awal), Beli dan Jual- File Gabungan/Hasil yang terdiri dari Sheets Data_Merged (Hasil PowerQuery), Laba kotor (PivotTable) dan Stock Akhir (PivotTable). Sebagai sample, saya membuat Nama Barang A s/d G dengan berbagai variasi sebagai berikut :- C tidak ada Pembelian- E tidak ada Penjualan- F tidak ada Stock (Awal)- G tidak ada Stock (Awal), Pembelian maupun Penjualan. Pertanyaan saya :Mengapa Waktu memilih Stock C atau E saja, baik pada Sheets Laba Kotor maupun Stock Akhir...tampilan PivotTablenya berubah sehingga hasilnya tidak sesuai harapan (Error), sedangkan jika kita memilih semua (Select All) tampilan PivotTablenya tidak bermasalah. Semoga para pemerhati dan Spesialis PivotTable (Mr. Kid) dapat membantu memberikan solusinya. Terima kasih. Salam,HK #yiv2690721061 #yiv2690721061 -- #yiv2690721061ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2690721061 #yiv2690721061ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2690721061 #yiv2690721061ygrp-mkp #yiv2690721061hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2690721061 #yiv2690721061ygrp-mkp #yiv2690721061ads {margin-bottom:10px;}#yiv2690721061 #yiv2690721061ygrp-mkp .yiv2690721061ad {padding:0 0;}#yiv2690721061 #yiv2690721061ygrp-mkp .yiv2690721061ad p {margin:0;}#yiv2690721061 #yiv2690721061ygrp-mkp .yiv2690721061ad a {color:#0000ff;text-decoration:none;}#yiv2690721061 #yiv2690721061ygrp-sponsor #yiv2690721061ygrp-lc {font-family:Arial;}#yiv2690721061 #yiv2690721061ygrp-sponsor #yiv2690721061ygrp-lc #yiv2690721061hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2690721061 #yiv2690721061ygrp-sponsor #yiv2690721061ygrp-lc .yiv2690721061ad {margin-bottom:10px;padding:0 0;}#yiv2690721061 #yiv2690721061actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2690721061 #yiv2690721061activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2690721061 #yiv2690721061activity span {font-weight:700;}#yiv2690721061 #yiv2690721061activity span:first-child {text-transform:uppercase;}#yiv2690721061 #yiv2690721061activity span a {color:#5085b6;text-decoration:none;}#yiv2690721061 #yiv2690721061activity span span {color:#ff7900;}#yiv2690721061 #yiv2690721061activity span .yiv2690721061underline {text-decoration:underline;}#yiv2690721061 .yiv2690721061attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2690721061 .yiv2690721061attach div a {text-decoration:none;}#yiv2690721061 .yiv2690721061attach img {border:none;padding-right:5px;}#yiv2690721061 .yiv2690721061attach label {display:block;margin-bottom:5px;}#yiv2690721061 .yiv2690721061attach label a {text-decoration:none;}#yiv2690721061 blockquote {margin:0 0 0 4px;}#yiv2690721061 .yiv2690721061bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2690721061 .yiv2690721061bold a {text-decoration:none;}#yiv2690721061 dd.yiv2690721061last p a {font-family:Verdana;font-weight:700;}#yiv2690721061 dd.yiv2690721061last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2690721061 dd.yiv2690721061last p span.yiv2690721061yshortcuts {margin-right:0;}#yiv2690721061 div.yiv2690721061attach-table div div a {text-decoration:none;}#yiv2690721061 div.yiv2690721061attach-table {width:400px;}#yiv2690721061 div.yiv2690721061file-title a, #yiv2690721061 div.yiv2690721061file-title a:active, #yiv2690721061 div.yiv2690721061file-title a:hover, #yiv2690721061 div.yiv2690721061file-title a:visited {text-decoration:none;}#yiv2690721061 div.yiv2690721061photo-title a, #yiv2690721061 div.yiv2690721061photo-title a:active, #yiv2690721061 div.yiv2690721061photo-title a:hover, #yiv2690721061 div.yiv2690721061photo-title a:visited {text-decoration:none;}#yiv2690721061 div#yiv2690721061ygrp-mlmsg #yiv2690721061ygrp-msg p a span.yiv2690721061yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2690721061 .yiv2690721061green {color:#628c2a;}#yiv2690721061 .yiv2690721061MsoNormal {margin:0 0 0 0;}#yiv2690721061 o {font-size:0;}#yiv2690721061 #yiv2690721061photos div {float:left;width:72px;}#yiv2690721061 #yiv2690721061photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2690721061 #yiv2690721061photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2690721061 #yiv2690721061reco-category {font-size:77%;}#yiv2690721061 #yiv2690721061reco-desc {font-size:77%;}#yiv2690721061 .yiv2690721061replbq {margin:4px;}#yiv2690721061 #yiv2690721061ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2690721061 #yiv2690721061ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2690721061 #yiv2690721061ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2690721061 #yiv2690721061ygrp-mlmsg select, #yiv2690721061 input, #yiv2690721061 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2690721061 #yiv2690721061ygrp-mlmsg pre, #yiv2690721061 code {font:115% monospace;}#yiv2690721061 #yiv2690721061ygrp-mlmsg * {line-height:1.22em;}#yiv2690721061 #yiv2690721061ygrp-mlmsg #yiv2690721061logo {padding-bottom:10px;}#yiv2690721061 #yiv2690721061ygrp-msg p a {font-family:Verdana;}#yiv2690721061 #yiv2690721061ygrp-msg p#yiv2690721061attach-count span {color:#1E66AE;font-weight:700;}#yiv2690721061 #yiv2690721061ygrp-reco #yiv2690721061reco-head {color:#ff7900;font-weight:700;}#yiv2690721061 #yiv2690721061ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2690721061 #yiv2690721061ygrp-sponsor #yiv2690721061ov li a {font-size:130%;text-decoration:none;}#yiv2690721061 #yiv2690721061ygrp-sponsor #yiv2690721061ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2690721061 #yiv2690721061ygrp-sponsor #yiv2690721061ov ul {margin:0;padding:0 0 0 8px;}#yiv2690721061 #yiv2690721061ygrp-text {font-family:Georgia;}#yiv2690721061 #yiv2690721061ygrp-text p {margin:0 0 1em 0;}#yiv2690721061 #yiv2690721061ygrp-text tt {font-size:120%;}#yiv2690721061 #yiv2690721061ygrp-vital ul li:last-child {border-right:none !important;}#yiv2690721061