Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
dinicholls
Creator II
Creator II

Can you create your own total in a pivot table?

Hi All,

I have a pivot table that's doing exactly what I want, bar the totals. This is how it looks currently:

          Total £

BS     4274.40

D       199025.65

SQ     2743.17

Total     206043.22

What I actually want it to do is take the D figure, and minus the BS and SQ figures, so the pivot would look like this:

          Total £

BS     4274.40

D       199025.65

SQ     2743.17

Total   200556.88

I can't alter any of the figures, multiplying by -1, as I need to show them as there are.

Is there any way of doing it?

Thanks

Di

1 Reply
sunny_talwar

May be something like this:

If(Dimensionality() = 0, Sum({<DimensionFieldName = {'D'}>} Measure) - Sum({<DimensionFieldName = {'BS', 'SQ'}>} Measure), Sum(Measure))