I have my data such that the dimensions are :
| Tier1 | Tier2 | Tier3 | Tier4 |
| Ana | Lee | Kevin | Tim |
| Ana | Peter | George | Smith |
| John | Peter | Snow | Kane |
I want to create a pie chart to show how many employees are in each Tier(Each pie in the chart would represent a Tier and would show distribution as count of employees in that). Since all these Tiers are dimensions, I am unable to find a solution. Could someone help me with this please.
