PercentTotal with Hierarchy

#1

I am using the PERCENTTOTAL formula to get a Stat % of total. The problem is that the Metric Set is using the total sum of the denominator when I have many locations displayed. I want to be able to see the % of Total by location. Location is in my Row.

Instead of everything showing at like 1% it should be more like 60% for each location…

image
image.png994×1227 23.9 KB

I hope this is enough to help.

Thank you!

Marcus

#2

Hi Marcus

You can put the hierarchy in the percenttotal formula as a 2nd argument.
So you would do PERCENTTOTAL($Total$, $Location$). This will break down the rows into a bucket for each location and then calculate the percenttotal of each value out of all the values within the same location.

Hope that helps