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 ROWS area and then choose Average.
B) Add sales to the VALUES area once and select both AVERAGE and SUM functions.
C) Add sales to the COLUMNS area.
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.
D
Computer Science & Information Technology
You might also like to view...
Which statement is false?
a. A DELETE statement removes rows from a table. b. A DELETE statement must specify the table from which to delete. c. A DELETE statement starts with the keyword DELETE. d. A WHERE clause must be present in a DELETE statement.
Computer Science & Information Technology
The actual photographed resolution is known as the ______ resolution.
A. native B. original C. optical D. raw
Computer Science & Information Technology