Group dates in a pivot table in Google Sheets
Create a pivot table on a new sheet from A1:C5. Put Date in Rows and Revenue in Values summarized by SUM. Group the Date rows by Year-Month.
Verified by PhilisAbout 60 secondsCreate a pivot table on a new sheet from A1:C5. Put Date in Rows and Revenue in Values summarized by SUM. Group the Date rows by Year-Month.
Step-by-step
Select the targetCreate a pivot table on a new sheet from A1:C5.
Complete the next actionPut Date in Rows and Revenue in Values summarized by SUM.
Apply the changeGroup the Date rows by Year-Month.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
The pivot table groups Revenue into Year-Month date buckets.
Common mistake
Starting with the wrong cell or range selected.
Troubleshooting
Re-select A1:C5 and repeat the final action. The pivot table groups Revenue into Year-Month date buckets.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Date | Region | Revenue |
| 2026-01-05 | North | 120 |
| 2026-01-19 | South | 180 |
| 2026-02-02 | North | 240 |
| 2026-02-16 | West | 210 |
Video transcript
- Open the prepared Practice spreadsheet.
- Select the target. Create a pivot table on a new sheet from A1:C5.
- Complete the next action. Put Date in Rows and Revenue in Values summarized by SUM.
- Apply the change. Group the Date rows by Year-Month.
- The pivot table groups Revenue into Year-Month date buckets.