topic Re: Pivot Table: Sum Rows in QlikView

Pivot Table: Sum Rows

microwin88x — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the following expression on a Pivot Table

IF(

SUM(SALES)>=0,

SUM(SALES),

The thing is I get values like:

100

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 — Fri, 05 Aug 2016 13:09:20 GMT

You can Use

if(Dimensionality()=0,

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

IF(

SUM(SALES)>=0,

SUM(SALES),

)

antoniotiman — Fri, 05 Aug 2016 13:10:25 GMT

Try

Sum(Aggr(

IF(

SUM(SALES)>=0,

SUM(SALES),

0),YouDimension))

Regards,

Antonio