Members lesson 25
Pivot project
Build a complete sales report with rows, columns, summaries, and filters.
What you will practice
- Build a row-and-column sales report
- Filter a report to selected records
- Choose the summary that answers the question
Lesson preview
Starting tableSales report
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Channel | Product | Amount | Status |
| 2 | East | Direct | Desk | 980 | Won |
| 3 | West | Partner | Chair | 640 | Pending |
| 4 | North | Online | Monitor | 720 | Won |
| 5 | East | Partner | Chair | 510 | Lost |
| 6 | West | Direct | Desk | 1,140 | Won |
| 7 | North | Partner | Chair | 460 | Pending |
| 8 | East | Online | Monitor | 830 | Won |