Maaf, kurang paham dengan : 1. akan digunakan untuk data yg lain > maksudnya akan digunakan untuk kalkulasi di lain sheet kah ? Andai benar, kalkulasi bisa merujuk ke sumber data pivot table dibanding merujuk ke pivot table
2. setiap akan kita ambil hrs dilakukan manual atau kita mengklik masing2 key tsb utk mendptkan data yg dicari > seluruh kategori, dan control no bisa ditampilkan seluruhnya ketika field kategori dan control no diletakkan di bagian Row. On Fri, Sep 4, 2015 at 7:13 PM, Samsudin [email protected] [belajar-excel] <[email protected]> wrote: > > > Dear Mr. Kid, > > Terima kasih atas pencerahan dan kasus ini saya sudah bisa jika > menggunakan pivot table tetapi karena data ini akan digunakan untuk data yg > lain makanya setiap akan kita ambil hrs dilakukan manual atau kita mengklik > masing2 key tsb utk mendptkan data yg dicari. > > Terima kasih > > > > Hormat saya, > > Samsudin > 08112810068 > > Dikirim dari perangkat Samsung E7 saya > > > -------- Pesan asli -------- > Dari: "'Mr. Kid' [email protected] [belajar-excel]" < > [email protected]> > Tanggal: 04/09/2015 20:05 (GMT+08:00) > Ke: BeExcel <[email protected]> > Subjek: Re: [belajar-excel] 3 kata kunci yg berbeda > > > > Pak Samsudin, > > Coba manfaatkan fitur Excel Pivot Table. Pada Excel 2010 ke atas, juga ada > fitur Power Pivot. Di Excel 2010, Power Pivot masih memerlukan > peng-install-an. Power pivot menjadi add in yang otomatis terinstall dan > ter-load mulai di Excel 2013. > > On Fri, Sep 4, 2015 at 6:44 PM, Samsudin [email protected] > [belajar-excel] <[email protected]> wrote: > >> >> >> Dear Master Excel, >> >> Saya punya masalah sebagai berikut ada data pemakaian spare part bulan >> dengan dg susunan tabelnya : >> 1. Control no >> 2. Date >> 3. Item no >> 4. Descript no >> 5. Categori >> 6. Qty >> 7. Unit >> 8. Amount >> 9. Cost >> >> Dari tabel tersebut saya ingin ringkasan yg terdiri : >> 1. Kolom pertama berisi control no (header) dan baris kedua dst berisi >> control no >> 2. Kolom kedua sampai kolom ke 31 berisi date (header) dan baris kedua >> dst berisi cost dari categori yg dipakai berdasarkan date dikeluarkannya >> spare part tsb. >> 3. Data ini sebagai key adalah categori >> >> Terima kasih atas pencerahannya. >> >> >> Hormat saya, >> >> Samsudin >> >> >> Dikirim dari perangkat Samsung E7 saya >> >> --------------------------------------------------------------------------------------------------- >> >> This message (including any attachments) contains confidential information >> intended >> for a specific individual and purpose, and is protected by law. If you are >> not the >> intended recipient, you should delete this message and hereby notified that >> any >> disclosure, copying, or distribution of this message (or any part thereof), >> or the >> taking of any action based on it, is strictly prohibited. No liability or >> responsibility >> is accepted if information or data is, for whatever reason corrupted or does >> not reach >> its intended recipient. No warranty is given that this email is free of >> viruses. The >> views expressed in this email are, unless otherwise stated, those of the >> author and >> not those of the Company or its management. The Company reserves the right >> to monitor, >> intercept and block emails addressed to its users or take any other action >> in accordance >> with its email use policy. >> >> > --------------------------------------------------------------------------------------------------- > > This message (including any attachments) contains confidential information > intended > for a specific individual and purpose, and is protected by law. If you are > not the > intended recipient, you should delete this message and hereby notified that > any > disclosure, copying, or distribution of this message (or any part thereof), > or the > taking of any action based on it, is strictly prohibited. No liability or > responsibility > is accepted if information or data is, for whatever reason corrupted or does > not reach > its intended recipient. No warranty is given that this email is free of > viruses. The > views expressed in this email are, unless otherwise stated, those of the > author and > not those of the Company or its management. The Company reserves the right to > monitor, > intercept and block emails addressed to its users or take any other action in > accordance > with its email use policy. > > >
