Turning a column of daily dates into a clean monthly report.
Last lesson ended with a warning: drag the Date field into Rows and you get one row for every single day. Rahul wanted a monthly sales report and got a 365-row scroll instead. Technically a summary. Practically useless.
Managers think in months, quarters and years. Grouping is how you make the pivot think that way too.
The magic right-click
Build the pivot from last lesson, drag Date into Rows, and if you see the daily mess:
1Right-click any date inside the pivot.
2Choose Group.
3Tick Months — and while the box is open, tick Years too (more on why in a moment).
4OK.
The 365 rows collapse into a tidy Jan, Feb, Mar list with a total per month. Modern Excel often does this automatically the moment you drag a date in — if your pivot already says Months and Quarters, Excel simply pre-ticked the boxes for you, and the right-click Group menu is where you change its mind.
🔒
Keep reading with Pro
You are reading the free preview. Module 1 of every course is free forever — Pro unlocks the rest of this lesson, every other module of every course, removes ads, and adds workbooks and certificates.