Forum Discussion
cmcgo3
1 year agoHelper II
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
2 Replies
- rajendraongole1Super User
- cmcgo3Helper II
Apologies. Thank you.
https://drive.google.com/file/d/1VO9xfk8O3zH0pe7nShJVP4fP0Myi2xud/view?usp=drive_link