Dear Para Master, Mohon pencerahan untuk rumus pengganti fungsi pivot.
Saya lampirkan filenya dimana biasanya saya menggunakan pivot dengan patokan mengambil angka pada kolom code sebagai patokannya. Terima kasih atas bantuannya. ttd niky n ========================================================== Please consider the environment before printing this email. This message is confidential and may also be privileged. If you are not the intended recipient, please notify me by return e-mail and delete this message from your system. If you are not the intended recipient, any use by you of this message is strictly prohibited. We reserve our right to pursue any available legal action based on the prevailing laws due to any misuse of this e-mail or information contained herein.
Rumus pengganti pivot.xls
Description: MS-Excel spreadsheet
