Total problem

piekepotloed — Fri, 27 Mar 2015 11:18:38 GMT

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

Re: Total problem

MK_QSL — Fri, 27 Mar 2015 11:31:38 GMT

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

topic Re: Total problem in QlikView

Total problem

Re: Total problem