Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Region Dimension (Region, Subregion, Country) and want to be able to display the % contribution of a Country against the Subregion it belongs to. Likewise, the % contribution of a Subregion against the Region it belongs to.
I tried using the ABOVE and TOP functions, but could not get it to work.
Any help is greatly appreciated.
I don't fully understand the question, but something like this?
sum(Contribution)/sum(total <Subregion> Contribution)
sum(Contribution)/sum(total <Region> Contribution)