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?
I would like to get the closing balance for each Id. The formula is so sample that ID- 111 (Opening Amount + Selling Amount - Buying Amount) for each date. The next date's Opening Amount will be previous date's Closing Amount. Please see at the above table.