You would like to see both average sales and total sales for a category in a pivot table.Which of these would best accomplish both a Total and an Average column on the field Sales?
A)Add sales to the VALUES area once and select both AVERAGE and SUM functions.
B)Add sales to the COLUMNS area.
C)Add sales to the ROWS area and then choose Average.
D)Add sales to the VALUES area and change its Value Field Settings to Average in the Summary value field by and then repeat, allowing it to default to SUM.

Question

Quizplus · Accepted Answer

Adding sales to the VALUES area and changing the Value Field Settings to Average in the Summary value field by and then repeating and allowing it to default to SUM will provide both a Total and an Average column for the field Sales.

You Would Like to See Both Average Sales and Total