Forum Discussion

cmcgo3's avatar
cmcgo3
Helper II
1 year ago

Hiearchy and Filters

This is probably a simple fix; but I cannot quite get it. 

 

In attached file, if I click on "Andrew Phillips" who is on Team "F" and region "Northeast", the first visual is correct; percentage is 33.77%.  In the next visuals down, titled "Region", I would like to calculate the percentage of all others within that region which would be Davis, Jackson, Williams, Davis, and Smith which should calculate to 24.73%.

In the final visual, I would like to calculate the percentage of all others within that team which would be B. Davis and J Davis, which should calculate to 22.78%.

 

https://1drv.ms/u/s!AuqlAZe1G3j7lxmki6Iv8SvxVk_4?e=gBnAgB