26 Replies Latest reply: Aug 1, 2015 3:30 AM by kyaw myo tun RSS

    How to made Calculation on Pivot Table?

      Dear Expert,

       

                  Can I make Calculation on Pivot Table? Let me explain the process.

      In this table, Firstly, I would like to get Total Buying Amount and Total Selling Amount for all date. So, I made a pivot table that have two expression is 1) sum(Buying Amount) 2) sum(Selling Amount) against ID. After that I would like to get Closing Balance for each ID. for exp, Closing balance for 111 is 900 , It can get in original table easily but I would like to know how to calculate it on Pivot table?

       

       

      Best Regards,

      Kyaw Myo Tun