PivotTable Drill
Exercise 3: Switch from sum to count
Task
See the number of sales for each rep. Summarize the values by Count.
Moves 0 (target 1)
FileHome
| Row Labels | Sum of Amount |
| Johnson | 33500 |
| Smith | 57500 |
| Williams | 45500 |
| Grand Total | 136500 |
See the number of sales for each rep. Summarize the values by Count.
This drill is for computer screens. On a phone you can review the steps.
- Click "Sum of Amount" in the Values area
- Choose Value Field Settings
- Choose Count and click OK
Key takeaway
If a field shows Count when you expected Sum, change it back on the same screen.
See Pivot Tables for details.