Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
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))