Grouping Dates in a Pivot Table
Bundling a real date field in a Pivot Table into years, quarters, months or days using Group Field. Excel adds helper fields such as Years (Date) and Quarters (Date) to the Fields pane.
When to use
Always tick Years as well when grouping Quarters across several years, or every Qtr1 is added together. Text dates cannot be grouped, so convert them to real dates first, and group by Days with a number such as 7 for weekly buckets.
See Lec 07.