Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
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))