Pinterest Pixel

Group Periods In Microsoft Excel Pivot Tables

Bryan
Excel has a cool feature that will group periods in your Excel Pivot Table automatically! Wondering how to make it work for you? See the easy steps below!
Group Periods In Microsoft Excel Pivot Tables | MyExcelOnline Group Periods In Microsoft Excel Pivot Tables | MyExcelOnline

Our data has an Order Date column that we will use for this.

Group Periods In Microsoft Excel Pivot Tables

Group Periods In Microsoft Excel Pivot Tables | MyExcelOnline

Download excel workbookGroup-Periods.xlsx

 

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

Group Periods In Microsoft Excel Pivot Tables

 

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

Group Periods In Microsoft Excel Pivot Tables

You will be surprised that Excel has automatically grouped your dates by Years and Quarters!

Group Periods In Microsoft Excel Pivot Tables

Expand these by pressing the Plus icon beside the years:

Group Periods In Microsoft Excel Pivot Tables

STEP 3: What if you do not want these groupings?

Just right click on your Pivot Table and select Ungroup

Group Periods In Microsoft Excel Pivot Tables

Now you have removed the groupings in your Pivot Table!

Group Periods In Microsoft Excel Pivot Tables

 

How to Group Periods in Excel Pivot Tables

 

If you like this Excel tip, please share it
Group Periods In Microsoft Excel Pivot Tables | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Group By Quarters and Years With Excel Pivot Tables

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...