PivotTable Drill
Exercise 6: Group dates by month
Task
The dates are listed one by one. Group them so you see monthly totals.
Moves 0 (target 1)
FileHome
| Row Labels | Sum of Amount |
| 2026/4/3 | 12000 |
| 2026/4/8 | 8000 |
| 2026/4/15 | 15000 |
| 2026/4/22 | 9000 |
| 2026/5/2 | 11000 |
| 2026/5/9 | 6000 |
| 2026/5/14 | 13000 |
| 2026/5/20 | 7000 |
| 2026/5/28 | 10000 |
| 2026/6/3 | 5000 |
| 2026/6/11 | 14000 |
| 2026/6/18 | 9500 |
| 2026/6/24 | 4500 |
| 2026/6/30 | 12500 |
| Grand Total | 136500 |
The dates are listed one by one. Group them so you see monthly totals.
This drill is for computer screens. On a phone you can review the steps.
- Right-click a date cell > Group
- Choose Months under By and click OK
Key takeaway
If you see "Cannot group that selection", the source dates contain text or blanks.
See Pivot Tables for details.