From the course: Excel 2013 Essential Training

Unlock the full course today

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

Grouping by other factors

Grouping by other factors - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Grouping by other factors

“

In addition to grouping data by date and time factors, Pivot Tables also gives us the possibility to pretty much create grouping on our own, sort of an ad hoc way. We're looking at the worksheet called OtherGrouping in our file 13-PivotTables. Imagine if somebody asks us to group data by the east region. Now, we don't really have an east region, we've got a northeast, we've got a southeast. You can move fields. For example, if we want to move southeast next to northeast, just click that cell, drag its bottom edge. Those two fields are now adjacent, northeast and southeast. The date is together. Suppose we want to create a grouping called East. Select just the two labels, Right-Click Group. Suddenly, we see a new row in the term GROUP 1. That's not very meaningful, so let's just call it East. Recognize there's a minus in front of it. Let's click the minus and before doing that, look at the total. We got a northeast and a southeast. This total here is going to be about 4000 or so. Let's…

Contents