PivotTable Drill
Exercise 4: Show the average per item with separators
Task
Show the average amount for each item, as whole numbers with thousands separators (#,##0).
Moves 0 (target 1)
FileHome
| Row Labels | Sum of Amount |
| File | 64500 |
| Notebook | 48500 |
| Pen | 23500 |
| Grand Total | 136500 |
Show the average amount for each item, as whole numbers with thousands separators (#,##0).
This drill is for computer screens. On a phone you can review the steps.
- "Sum of Amount" > Value Field Settings
- Choose Average
- Click Number Format at the bottom left, set #,##0, and click OK
Key takeaway
Averages often have long decimals, so set the number format too.
See Pivot Tables for details.