PivotdrillRevenue by region
Build a pivot that shows total Revenue for each Region.
Source data: Sales orders, 2025 (48 rows)
| Date | Region | Rep | Product | Units | Revenue |
|---|---|---|---|---|---|
| 2025-01-01 | East | Omar | Dock | 3 | $473.47 |
| 2025-01-03 | South | Noah | Laptop | 1 | $986.09 |
| 2025-01-16 | East | Omar | Monitor | 14 | $3,141.76 |
| 2025-01-21 | North | Liam | Monitor | 5 | $1,095.32 |
| 2025-02-13 | West | Leo | Dock | 11 | $1,734.69 |
| 2025-02-23 | East | Zoe | Dock | 9 | $1,298.01 |
| 2025-02-28 | North | Ava | Keyboard | 9 | $389.00 |
| 2025-03-10 | West | Ivy | Dock | 7 | $1,119.00 |
PivotTable Fields
Add each field to an area.
- Date Date
- Abc Region
- Abc Rep
- Abc Product
- 123 Units
- 123 Revenue
Filters
Optional
Columns
Optional
Rows
Add a field
Values
Add a field
PivotTable
Add a field to Values to see numbers.