Ever encountered a needing to add quarters to pivot table?

I was faced with this same scenario and looking at my data on hand, I only had sales numbers for each individual day.

Grouping these would take a ton of effort & complex formulas!

Thankfully there is the Pivot Table way to add quarters to pivot table, which is quick, easy, and reduces the risks of making any errors….and it makes updating the report easy with any new additional data!

Want to know How To Add Quarters to Pivot Table in Excel?

*** Watch our video and step by step guide below with a free downloadable Excel workbook on Excel pivot table group by quarter***

Watch on YouTube and give it a thumbs up 👍

Group By Quarters and Years With Excel Pivot Tables | MyExcelOnline

In the example below I show you how to add quarters to pivot table in Excel:

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Insert a new Pivot table by clicking on your data and going to Insert > Pivot Table > New Worksheet or Existing Worksheet

group-by-quarters-and-years-01

 

STEP 2: In the ROWS section put in the Order Date field.

Notice that in Excel 2016 (the version that I am using) it will automatically Group the Order Date into Years & Quarters:

group-by-quarters-and-years-02

 

STEP 3: If you do not have Excel 2016, right-click on any Row value in your Pivot Table and select Group 

group-by-quarters-and-years-03

 

STEP 4: In the Grouping dialogue box, Excel was able to determine our date range (minimum date and maximum date).

Make sure only Quarters and Years are selected (which will be highlighted in blue).

This will group Excel pivot table quarters. Click OK. 

group-by-quarters-and-years-04

 

Notice that a Years field has been automatically added to our PivotTable Fields List.  This is cool, as we can use this field for further Pivot Table analysis:

group-by-quarters-and-years-05

 

STEP 5: In the VALUES area put in the Sales field. This will get the total of the Sales for each Quarter-Year date range:

group-by-quarters-and-years-06

 

Now we have our sales numbers grouped by Years & Quarters!

Notice that we can improve the formatting:

add quarters to pivot table

 

STEP 6: Click the Sum of SALES and select Value Field Settings

group-by-quarters-and-years-08

 

STEP 7: Select Number Format

group-by-quarters-and-years-09

 

STEP 8: Select Currency. Click OK.

group-by-quarters-and-years-10

This is how to add years and quarters to Pivot Table. You now have your total sales for each quarterly period!

group-by-quarters-and-years-11

 

PIVOT BANNER

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn