Pivot tables have a built-in feature to group dates by year, month, and quarter.

In the example shown, a pivot table is used to summarize sales by year and quarter.

pivot table group by quarter field list

pivot table group by quarter field list

pivot table group by quarter field list

pivot table group by quarter field list

pivot table group by quarter field list

Date field grouped by Years and Quarters

Value field is set to sum sales