Dear Mr Kid,
Oh ternyata sudah dibahas toh, tapi saya koq ga tau yah. Mungkin karena email saya sedang ada gangguana kali yah. Tapi terima kasih Mr Kid atas solusinya. Salam, DD From: 'Mr. Kid' [email protected] [belajar-excel] [mailto:[email protected]] Sent: 13 Maret 2015 06:24 To: BeExcel Subject: Re: [belajar-excel] Pivot Tabel Hai DD, Sebenarnya hal ini sudah dibahas beberapa saat lalu di thread Pak Haris tentang Problem Pivot Table pada masalah nomor 1. Berikut cuplikan solusi yang ada disana : >> di coretan tentang pivot table yang ada disini >> <http://excel-mr-kid.blogspot.com/2013/04/pivot-table-1-kenalan.html> di >> bagian 'Menata Data' ada pembahasan tentang hal ini. >> jadi, seluruh fields dikeluarkan dulu dari pivot table (agar pivot tablenya >> kosongan) -> refresh pivot table -> pivot table options -> tab data -> pilih >> None pada retain item -> OK -> susun layout >> jika pada pivot cache baru (baru buat pivot table dan masih kosongan) -> >> pivot table options -> tab data -> pilih None di retain item -> OK -> susun >> layout Wassalam, Kid. On Thu, Mar 12, 2015 at 7:27 PM, Dede [email protected] [belajar-excel] <[email protected]> wrote: Dear BeExceller, Mohon pencerahan terkait masalah ini, ceritanya gini yah.... Saya buat Pivot dengan data pertama, kemudian saya refresh karena ada edit sedikit data tapi data lama koq masih tericord di pivot yah. Biar pivot datanya sesuai data terupdate itu gimana caranya yah...? (Biar angka 111 nya hilang) Salam, DD _____ This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual to whom it is addressed. If you have received this email in error please send it back to the person that sent it to you. Any views or opinions presented are solely those of its author and do not necessarily represent those of NABATI or any of its subsidiary companies. Unauthorized publication, use, dissemination, forwarding, printing or copying of this email and its associated attachments is strictly prohibited.
