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