Wrong Total in pivot-table

[kris_vliegen]

Hi All,

I've created a pivot-table

As you can see is the total for 'Totaal 2013' and 'Contant 2013' wrong and should be 1.222.861 and 467.162

I use this expression:

=if(sum( { $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >}Totaal_Liter) > 0,
sum( { $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >}Totaal_Liter) ,
sum( { $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >}CapLiter))

And for Station-type and store set on 'Show Parttial sums'

Why is he counting the wrong numbers?

Regards,

Kris

[Gysbert_Wassenaar · Accepted solution]

I think you'll have to wrap your expression in another sum:

=sum({ $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >} aggr(

if(sum( { $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >}Totaal_Liter) > 0,
sum( { $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >}Totaal_Liter) ,
sum( { $ < Datum1 = {'$(vMaxDate)' }, CalYear =, CalQuarter= , CalMonth=, CalDay= >}CapLiter)),

Dim1, Dim2, ... , DimN))

Replace Dim1, Dim2, ... , DimN with the dimensions of your pivot table

[kris_vliegen]

Thanks, this seems to work!

Regards,

Kris