Excel PivotTablesLesson 67Free preview

Excel PivotTable Group

This lesson is part of Excel · All levels

Summary

Groups on the PivotTable group raw data into more readable categories, such as dates into months or quarters, and numbers into ranges such as 0-50, 51-100. The grouping is done by right-clicking on the previous Group item, and can be canceled at any time. The result is a more concise live report without changing the source data.

Key points

Group group dates to months/quarter and numbers to range
Access by right-clicking the pivot item and then Group
Automatic group is available for field-type dates
Ungroup returns the item to its original form

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.