1. Industry
Send to a Friend via Email

Your suggestion is on its way!

An email with a link to:


was emailed to:

Thanks for sharing About.com with others!

You can opt-out at any time. Please refer to our privacy policy for contact information.

How to Configure Excel 2010 Pivot Table for Business Intelligence


10 of 15

Add Grouping for Date Fields
Photo © Microsoft

Add Groupings for date field

The Grouping function allows us to organize dates into years, months, quarters, etc. This will help summarize the data and make it easier for the user to interact with it. Right click on one of the date column headers and choose Group which brings up the Grouping form.

©2014 About.com. All rights reserved.