I have a number of data entries for the employees in my department, and I'm trying to set up a pivot table that would give me their average error rate in comparison to the average error rate of the whole department.

My raw data entries look something like this:

Sample data.JPG

I was able to create a Pivot Chart that shows me a line with the average for each one of the individual employees, and for the specific Teams as well, but I cannot figure out how to have one line where the total average is shown, so that I can compare how the individual employees/teams are doing in comparison to that base line. Any suggestions?

Pivot Table.JPG

Setup.JPG


Thanks,

Menegocci