PivotTable Drill
Exercise 5: Sort by amount, largest first
Task
Sort the reps by total amount, largest first.
Moves 0 (target 1)
FileHome
| Row Labels | Sum of Amount |
| Johnson | 33500 |
| Smith | 57500 |
| Williams | 45500 |
| Grand Total | 136500 |
Sort the reps by total amount, largest first.
This drill is for computer screens. On a phone you can review the steps.
- Right-click an amount cell
- Sort > Sort Largest to Smallest
Key takeaway
Sorting from a row label sorts by name; sorting from a value sorts by amount.
See Pivot Tables for details.