“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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 O. D. in 19 mins

Make a data table in excel with two variables that calculates the average cost per call in the data table for each level of total call minutes logged and at each average cost per minute.

Solved by S. J. in 22 mins

trying to figure out average handling time per tenure for employment

Solved by S. H. in 18 mins

trying to calculate average calls, emails, outbound and welcome per tenure per day based on working hours and AHT

Solved by D. W. in 24 mins

I have a table in excel that has:
Location Car Class Revenue NumberofCars Overhead Profit Profit per car
Downtown Economy $804,931 5,564 $278,200 $526,731 94.67
Airport Economy
Airport Premium
Downtown Premium
I need to do a pivot table that will display the Average profit per car for Economy as well as Premium
Then showing the average profit per location
Then Average profit per car for all cars
I am not clear on how to use Average with the pivot table

Solved by Z. D. in 16 mins