Percentage by Region

[stevejones1]

Hi

Please find the attached doc , i am trying to display the % by Region for each quarter , but unable to figure out expression , i am able to get expression for individual Region but i want to display 1 row for 1 region, currently my region values are duplicating.

Thanks!

[sunny_talwar · Accepted solution]

Try these two expression

Alt($(eAdjExtCostAsiaPQ2), $(eAdjExtCostAsiaPQ1))

Alt($(eAdjExtCostEMEAPQ1), $(eAdjExtCostEMEAPQ2))

[duncanblaine]

Hi Steve

Looks like Sunny just got in there before me

From what I can see, it looks like the denominator in your Percentages is missing something.

In a simplified example:

Sum({<[SalesOutZyme.Type]={'SPR'}>}SalesOutZyme.AdjExtCost) / Sum(TOTAL <Geo.Region> {<[SalesOutZyme.Type]={'SPR'}>}SalesOutZyme.AdjExtCost)

The TOTAL qualifier will allow the percentage to aggregate across all values in the specified dimension.

I've attached the QVW which includes a new Pivot table which contains the new expressions. You might need to amend to swap in the variables.