Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be something like this:
If(Dimensionality() = 0, Sum({<DimensionFieldName = {'D'}>} Measure) - Sum({<DimensionFieldName = {'BS', 'SQ'}>} Measure), Sum(Measure))