Forum Discussion
Hierachies and Filtering
This is probably a simple fix; but I cannot quite get it.
Ultimately, I am trying to create visual (preferably gauge) to show "Andrew Phillips" percentage as well as separate visual to compare the others included on his "Team F", (B. Davis and J. Davis) and thirdly, a visual to compare others included in his region "Northeast", (B. Davis, Jackson, Williams, J. Davis, and Smith).
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%.
- Anonymous1 year ago
Hi mh2587 ,thanks for the quick reply, I'll add more.
Hi cmcgo3 ,
The detailed content can be found in the attachment.
Best Regards,
Wenbin Zhou