1. Industry
Send to a Friend via Email

Your suggestion is on its way!

An email with a link to:

http://newtech.about.com/od/tutorials/ss/How-To-Configure-Excel-2010-Pivot-Table-For-Business-Intelligence_10.htm

was emailed to:

Thanks for sharing About.com with others!

How to Configure Excel 2010 Pivot Table for Business Intelligence

By

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.