Calculation on Partial Sum

[#1]

Greetings

Please help to calculate the difference of the partial sum on Pivot table.

Please advise how can I calculate the difference between the sum of 1st column vs 2nd column and so on on a Pivot Table.

Thanks!!

[sasikanth · Accepted solution]

HI,

t

use above function

Ex:

Sum(sales)-above(sum(sales))

[#3]

Thanks Sunny!

But unfortunately it's not working.

Please find attach the qvw file.

Thanks.

[sasikanth]

Hi,

PFA , see the last column

[#5]

Thanks Sunny.

Is it possible if only last column will be displayed?

Thanks.

[sasikanth]

HI,

i don`t think so , it will apply on all columns

[sunny_talwar]

By last column you mean just the totals column?

[#8]

Yes. Just the total column.

Thanks.