Pivot Table Shows Wrong Sum

[Qvmaster2019]

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 · Accepted solution]

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]

Thanks swuehl!

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

Thanks a lot!