Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculation on Partial Sum

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!!

1 Solution

Accepted Solutions
sasikanth
Master
Master

HI,

t

use above function

Ex:

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

View solution in original post

7 Replies
sasikanth
Master
Master

HI,

t

use above function

Ex:

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

Not applicable
Author

Thanks Sunny!

But unfortunately it's not working.

Please find attach the qvw file.

Thanks.

sasikanth
Master
Master

Hi,

PFA , see the last column

Not applicable
Author

Thanks Sunny.

Is it possible if only last column will be displayed?

Thanks.

sasikanth
Master
Master

HI,

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

sunny_talwar

By last column you mean just the totals column?

Not applicable
Author

Yes. Just the total column.

Thanks.