topic Pivot Table Shows Wrong Sum in QlikView

Pivot Table Shows Wrong Sum

Qvmaster2019 — Tue, 02 Oct 2012 10:15:10 GMT

Please take a look at the column "QTR Growth (Product)" which is just the product of "QTR Index" and "Weight".

It's total should be around 100% but what it is doing is multiplying Total of QTR Index by the Total of Weight.

How can i correct this?

Please advise.

swuehl — Tue, 02 Oct 2012 10:28:16 GMT

So you want a sum of rows here?

Please check the HELP for an explanation of sum-of-rows in a pivot table using advanced aggregation, I think your expression could look like

=sum(aggr(

sum([2011 Sales])/sum(total <[Product Group]> [2011 Sales]) * sum(Data-(Data*AdjustedFactor))/100,

[Product Group],Mnemonic))

Qvmaster2019 — Tue, 02 Oct 2012 10:30:05 GMT

I did not know there's a help file for that sum-of-rows.

Thanks a lot!