Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
This is what I'm facing in a pivot table:
Header 1 | Header 2 | Header 3 |
---|---|---|
Group1 | Group1.1 | 250 |
Group1.2 | 125 | |
TotalGroup1 | 375 | |
Group2 | Group2.1 | 100 |
Group2.2 | 200 | |
TotalGroup2 | 300 | |
Result | 675 |
But I want the result to be the subtractions off TotalGroup1 - TotalGroup2 = 75
What should I do to get this?
Thanks
Load * Inline
[
Header 1, Header 2, Header 3
Group1, Group1.1, 250
Group1, Group1.2, 125
Group2, Group2.1, 100
Group2, Group2.2, 200
];
Create a Pivot Table
Dimension
[Header 1]
[Header 2]
Expression
IF(Dimensionality() = 0 and SecondaryDimensionality()= 0, Max(TOTAL Aggr(SUM([Header 3]),[Header 1])) - Min(TOTAL Aggr(SUM([Header 3]),[Header 1])), SUM([Header 3]))
Go to Presentation Tab
Select [Header 1] and Tick Show Partial Sums
Select [Header 2] and Tick Show Partial Sums