Excel 2007 PivotTables Recipes: A Problem-Solution Approach

CHAPTER 5Grouping and TotalingPivot Table Data

When you add date fields to a pivot table, you can show the dates individually, or group them into larger units, such as years, quarters, or months. This adds flexibility to the pivot table, and enables you to do things like comparing the results from one year to another, or creating a running total by quarter.

You can also group numeric fields, when you add them to the Row Labels or Column Labels area of the pivot table. By using this feature, you can group the numbers into larger chunks, such as groups of 10 or 25. If comparing test scores, or results by age, you can look at larger segments of the population, instead of individual scores or ages.

It's also possible to manually group text items ...