From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Grouping options

Grouping options - Microsoft Excel Tutorial

From the course: Excel PivotTables: Mastering PivotTables and PivotCharts

Start my 1-month free trial

Grouping options

“

- [Instructor] Another powerful pivot table tool is the ability to group data together. And what this lets you do is define custom collections, or groups of values, and analyze them as a bucket rather than individual items. So to show you an example, let's start by only showing movies with the word star. And here you can see that we have a number of films in the Star Trek series, and a number of films in the Star Wars series. So right now, our data's at the title level, meaning that these revenue and budget numbers that we're looking at are specific to each individual title within those groups. Now, if we wanted to lump or group those together, and analyze them at a broader level, what I can do is actually just select the fields that I'm interested in. Let's start with these six individual Star Wars titles, and I can either go into my Pivot Table Tool Analyze tab, or you can find the Group pane, or I can simply right click and choose Group option. And when I do this, it's a little bit…

Contents