Members lesson 21
Your first pivot table
Group sales into useful reports and total each group with SUM.
What you will practice
- Add a field to pivot rows
- Summarize a numeric field with SUM
- Change row order and totals
Lesson preview
Starting tableSales
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Region | Rep | Product | Amount |
| 2 | East | Ana | Desk | 980 |
| 3 | West | Bo | Chair | 640 |
| 4 | North | Cam | Desk | 720 |
| 5 | East | Dee | Monitor | 510 |
| 6 | West | Ana | Desk | 1,140 |
| 7 | North | Bo | Chair | 460 |
| 8 | East | Cam | Chair | 830 |