Total problem

[piekepotloed]

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

[MK_QSL]

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