How to made Calculation on Pivot Table?

[#1]

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

[settu_periasamy]

Hi,

Can you give the closing balance formula? what is your dimensions?

is it possible to post the sample qvw to understand better?

[#3]

Dear settu,

            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.

Best Regards,

Kyaw Myo Tun

[settu_periasamy]

Hi,

Can you tell about the 5th row, how the closing balance as 900?

[#5]

Dear settu,

     That is my mistake and the closing amount will be 1500. Sorry for my mistake.

Best Regards,

Kyaw Myo Tun

[settu_periasamy]

is there any specific aggregation to do this, if not,

you can directly apply the below formula, right?

=(Sum(Opening Amount) + Sum(Selling Amount))-Sum(Buying Amount)

find the attached for reference

[#7]

Dear settu,

              I have some aggregations in my pivot table as I mentioned above and I also want to do calculation on that aggregated table.

Regards,

Kyaw Myo Tun

[settu_periasamy]

is it possible post the sample qvw and expected output?

[#9]

Dear settu,

        I am trying to upload the qvd but I can't see the attach button. Can you advice me please?

Regards,

Kyaw Myo Tun

[settu_periasamy]

When you are replying, top right corner in the reply window, there is option , Use Advanced editor.

click that. then, in the bottom right corner, there is attach symbol