Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try these two expression
Alt($(eAdjExtCostAsiaPQ2), $(eAdjExtCostAsiaPQ1))
Alt($(eAdjExtCostEMEAPQ1), $(eAdjExtCostEMEAPQ2))
Try these two expression
Alt($(eAdjExtCostAsiaPQ2), $(eAdjExtCostAsiaPQ1))
Alt($(eAdjExtCostEMEAPQ1), $(eAdjExtCostEMEAPQ2))
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.