I have data that is similar to the chart below with multiple entries for each individual. I want to be able to create a pivot chart that shows how many tasks of each complexity type an individual has completed vs the average of all the individuals where I can use a slicer to change the individual. What I can't figure out is how to get the overall average on there. Any help is appreciated
Name | Task Complexity |
Joe | High |
Sarah | Medium |
Mohamad | Low |
Dilpreet | Other |
Joe | Medium |
Sarah | Low |
Mohamad | Other |
Dilpreet | Medium |
Dilpreet | High |
Joe | Low |
Joe | Other |
Sarah | Low |
Sarah | Low |
Mohamad | High |