Dear Mr. Kid,
Well done, thanks banget pencerahannya master.Sangat membantu sekali, hasil
penampakannya seperti dibawah ini
Sesuai dengan yang saya inginkan.sekali lagi thanks a lot Mr. Kid.Semoga Allah
membalas kebaikan para Master yang berbaik hati selalu berbagi ilmu, amiin...
salam,Netty
On Monday, November 13, 2017 10:12:55 PM WIB, 'Mr. Kid'
[email protected] [belajar-excel] <[email protected]> wrote:
Hai Netty,
Coba seluruh records di kolom tanggal yang dirujuk oleh pivot data source
dibuat memiliki format number yang sama.Misal, slicer tanggal pada pivot table
yang merujuk ke area range A1:A17 dengan kolom A adalah kolom tanggal yang
ditampilkan dalam slicer.Blok kolom A (seluruh baris di kolom A), atur format
cells tab Number, pilih Date atau custom dengan tampilan format
DD-MMM-YYYYKemudian lakukan refresh all (ribbon atau menu DATA -> grup menu
Connections -> klik icon Refresh All).
Regards,Kid
2017-11-13 17:05 GMT+07:00 Netty Wuryanti [email protected]
[belajar-excel] <[email protected]>:
Dear Para master,
Mohon bantuannya para Master disini.Saya ada kesulitan cara mengganti format
angka ke nama bulan di slicer, menu apa yang harus saya klik?, sedangkan di
source data sudah tersetting format date namun saat di slicer jadi berubah ke
format angka seperti dibawah ini.
atas bantuannya saya ucapkan banyak terima kasih
salam,Netty
#yiv6543252918 #yiv6543252918 -- #yiv6543252918ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv6543252918
#yiv6543252918ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv6543252918
#yiv6543252918ygrp-mkp #yiv6543252918hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv6543252918 #yiv6543252918ygrp-mkp #yiv6543252918ads
{margin-bottom:10px;}#yiv6543252918 #yiv6543252918ygrp-mkp .yiv6543252918ad
{padding:0 0;}#yiv6543252918 #yiv6543252918ygrp-mkp .yiv6543252918ad p
{margin:0;}#yiv6543252918 #yiv6543252918ygrp-mkp .yiv6543252918ad a
{color:#0000ff;text-decoration:none;}#yiv6543252918 #yiv6543252918ygrp-sponsor
#yiv6543252918ygrp-lc {font-family:Arial;}#yiv6543252918
#yiv6543252918ygrp-sponsor #yiv6543252918ygrp-lc #yiv6543252918hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv6543252918
#yiv6543252918ygrp-sponsor #yiv6543252918ygrp-lc .yiv6543252918ad
{margin-bottom:10px;padding:0 0;}#yiv6543252918 #yiv6543252918actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv6543252918
#yiv6543252918activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv6543252918
#yiv6543252918activity span {font-weight:700;}#yiv6543252918
#yiv6543252918activity span:first-child
{text-transform:uppercase;}#yiv6543252918 #yiv6543252918activity span a
{color:#5085b6;text-decoration:none;}#yiv6543252918 #yiv6543252918activity span
span {color:#ff7900;}#yiv6543252918 #yiv6543252918activity span
.yiv6543252918underline {text-decoration:underline;}#yiv6543252918
.yiv6543252918attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv6543252918 .yiv6543252918attach div a
{text-decoration:none;}#yiv6543252918 .yiv6543252918attach img
{border:none;padding-right:5px;}#yiv6543252918 .yiv6543252918attach label
{display:block;margin-bottom:5px;}#yiv6543252918 .yiv6543252918attach label a
{text-decoration:none;}#yiv6543252918 blockquote {margin:0 0 0
4px;}#yiv6543252918 .yiv6543252918bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv6543252918
.yiv6543252918bold a {text-decoration:none;}#yiv6543252918 dd.yiv6543252918last
p a {font-family:Verdana;font-weight:700;}#yiv6543252918 dd.yiv6543252918last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv6543252918
dd.yiv6543252918last p span.yiv6543252918yshortcuts
{margin-right:0;}#yiv6543252918 div.yiv6543252918attach-table div div a
{text-decoration:none;}#yiv6543252918 div.yiv6543252918attach-table
{width:400px;}#yiv6543252918 div.yiv6543252918file-title a, #yiv6543252918
div.yiv6543252918file-title a:active, #yiv6543252918
div.yiv6543252918file-title a:hover, #yiv6543252918 div.yiv6543252918file-title
a:visited {text-decoration:none;}#yiv6543252918 div.yiv6543252918photo-title a,
#yiv6543252918 div.yiv6543252918photo-title a:active, #yiv6543252918
div.yiv6543252918photo-title a:hover, #yiv6543252918
div.yiv6543252918photo-title a:visited {text-decoration:none;}#yiv6543252918
div#yiv6543252918ygrp-mlmsg #yiv6543252918ygrp-msg p a
span.yiv6543252918yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv6543252918
.yiv6543252918green {color:#628c2a;}#yiv6543252918 .yiv6543252918MsoNormal
{margin:0 0 0 0;}#yiv6543252918 o {font-size:0;}#yiv6543252918
#yiv6543252918photos div {float:left;width:72px;}#yiv6543252918
#yiv6543252918photos div div {border:1px solid
#666666;min-height:62px;overflow:hidden;width:62px;}#yiv6543252918
#yiv6543252918photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv6543252918
#yiv6543252918reco-category {font-size:77%;}#yiv6543252918
#yiv6543252918reco-desc {font-size:77%;}#yiv6543252918 .yiv6543252918replbq
{margin:4px;}#yiv6543252918 #yiv6543252918ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv6543252918 #yiv6543252918ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv6543252918
#yiv6543252918ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv6543252918
#yiv6543252918ygrp-mlmsg select, #yiv6543252918 input, #yiv6543252918 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv6543252918
#yiv6543252918ygrp-mlmsg pre, #yiv6543252918 code {font:115%
monospace;}#yiv6543252918 #yiv6543252918ygrp-mlmsg *
{line-height:1.22em;}#yiv6543252918 #yiv6543252918ygrp-mlmsg #yiv6543252918logo
{padding-bottom:10px;}#yiv6543252918 #yiv6543252918ygrp-msg p a
{font-family:Verdana;}#yiv6543252918 #yiv6543252918ygrp-msg
p#yiv6543252918attach-count span {color:#1E66AE;font-weight:700;}#yiv6543252918
#yiv6543252918ygrp-reco #yiv6543252918reco-head
{color:#ff7900;font-weight:700;}#yiv6543252918 #yiv6543252918ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv6543252918 #yiv6543252918ygrp-sponsor
#yiv6543252918ov li a {font-size:130%;text-decoration:none;}#yiv6543252918
#yiv6543252918ygrp-sponsor #yiv6543252918ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv6543252918
#yiv6543252918ygrp-sponsor #yiv6543252918ov ul {margin:0;padding:0 0 0
8px;}#yiv6543252918 #yiv6543252918ygrp-text
{font-family:Georgia;}#yiv6543252918 #yiv6543252918ygrp-text p {margin:0 0 1em
0;}#yiv6543252918 #yiv6543252918ygrp-text tt {font-size:120%;}#yiv6543252918
#yiv6543252918ygrp-vital ul li:last-child {border-right:none
!important;}#yiv6543252918
