| A | B | C | D | |
|---|---|---|---|---|
| 1 | Region | Product | Quarter | Sales |
| 2 | North | Laptop | Q1 | 12,450 |
| 3 | South | Monitor | Q1 | 8,320 |
| 4 | East | Laptop | Q1 | 7,890 |
| 5 | North | Keyboard | Q2 | 15,230 |
| 6 | South | Monitor | Q2 | 9,150 |
| 7 | East | Keyboard | Q2 | 3,210 |
| Q1 | Q2 | Total | ||
|---|---|---|---|---|
| 1 | East | 7,890 | 3,210 | 11,100 |
| 2 | North | 12,450 | 15,230 | 27,680 |
| 3 | South | 8,320 | 9,150 | 17,470 |
| 4 | Grand Total | 28,660 | 27,590 | 56,250 |