Pivot Table Percentages with Master Dimension Drill Down

[mskusace]

I have some demographic information for the country. One of the columns is "Ethnicity". I have a pivot table right now and I managed to show the percentage with the 

Count([Count of People])/Count(TOTAL <[Country]> [Count of People])

The columns on the pivot table are:

A master dimension which drills down from Country -> State/Province -> City. Right now, my formula only will show the percentage based on the Country, even if a specific State or City is selected. I want it to dynamically update so if someone selects a specific State, the percentages will be for that state. If someone selects a city, the percentages will be for that city.

Any guidance would be greatly appreciated.

[sasikanth · Accepted solution]

Hi ,
Try below expressions

1) Count(TOTAL [Count of People] )
(OR )
2) Count(TOTAL <Country,City,State> [Count of People] )

[mskusace]

That second formula works perfectly! Thank you so much! Set analysis has been coming up a lot for me and I am trying to learn more about it.