Hi I'm stuck with a pivot chart trying to calculate the average of mistakes per area. I have the chart to that point. per week and area and shows bar for total amount and total mistakes per area and an average of those mistakes base on totals per area. I will like to show an overall average. For example if I filter for a week for all areas that I can see the average per area and the overall average. please help.
Solved by K. D. in 18 mins