Pivot Table: Sum Rows

[microwin88x]

Hello,

I have the following expression on a Pivot Table

IF(

SUM(SALES)>=0,

SUM(SALES),

0)

The thing is I get values like:

0

0

10

100

0

Total: 0 (Checking the Option: Show Partial Sums under Presentation)

That is OK. But I want to sum all rows in the end, getting value Total: 110

Do you know how could I do that?

Thank you!!!

[Anonymous]

You can Use

if(Dimensionality()=0,

sum(aggr(sum(Sales),Dimension Values)),

IF(

SUM(SALES)>=0,

SUM(SALES),

0)

)

[antoniotiman · Accepted solution]

Try

Sum(Aggr(

IF(

SUM(SALES)>=0,

SUM(SALES),

0),YouDimension))

Regards,

Antonio