PivotTable Drill
Exercise 2: Add Branch to Columns for a cross-tab
Task
Split each rep's total by branch too. Put Branch in Columns.
Moves 0 (target 1)
FileHome
| Row Labels | Sum of Amount |
| Johnson | 33500 |
| Smith | 57500 |
| Williams | 45500 |
| Grand Total | 136500 |
Split each rep's total by branch too. Put Branch in Columns.
This drill is for computer screens. On a phone you can review the steps.
- Drag Branch from the field list to the Columns area
- Another way: Branch ▼ > Add to Column Labels
Key takeaway
With fields in both Rows and Columns, you get in one step what would take dozens of SUMIFS formulas.
See Pivot Tables for details.