Total problem in Pivot table

[piekepotloed]

Hi,

I've an expression that looks like this:

sum({$<Grootboek_type_revenue={2}, Maand*={"*"}>}Dgbk_bedrag)*if(Left(ArcusRapportageNiveau,2)='29' or Left(ArcusRapportageNiveau,2)='43' ,1,-1))+(sum({$<Grootboek_type_revenue={3}, Maand*={"*"}>}Dgbk_bedrag))

If I check the "Show Partial Sums"checkbox at the dimension tab, the total shown is not the same as the total of the expressions. How can I get this wrigth?

Kind regards,

Peter

[MK_QSL]

Use Dimensionality() or SecondaryDimensionality()...

Provide your sample file to work..

[piekepotloed]

Hi Manisch,

Thanks for your support, but I'm not getting there...I provide a sample file as you've asked for.

Peter

[tresesco · Accepted solution]

Like this?

=Sum(Aggr((sum({$<Grootboek_type_revenue={2}, Maand*={"*"}>}Dgbk_bedrag)*if(Left(ArcusRapportageNiveau,2)='29' or Left(ArcusRapportageNiveau,2)='43' ,1,-1))+(sum({$<Grootboek_type_revenue={3}, Maand*={"*"}>}Dgbk_bedrag)),ArcusTelNiveau,ArcusRapportageNiveau))