Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks, this seems to work!
Regards,
Kris