Courses / PivotTables & PivotCharts
21. Grouping dates
Combining date field members into buckets like Years, Quarters, Months, or custom intervals.
PivotTables / Excel
Grouping dates
Combining individual date values into buckets like Years, Quarters, Months, or custom intervals so you can summarize time-based data quickly.
"I have hundreds of rows of dates and I want totals by quarter — not a row for every single day."
Date grouping takes a date field in a PivotTable and aggregates its members into larger time buckets (Years, Quarters, Months, Days) or custom numeric intervals so you can analyze trends at the time scale you care about.
"I have hundreds of rows of dates and I want totals by quarter — not a row for every single day."
Date grouping takes a date field in a PivotTable and aggregates its members into larger time buckets (Years, Quarters, Months, Days) or custom numeric intervals so you can analyze trends at the time scale you care about.