From the course: Excel 2016 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Grouping by other factors
From the course: Excel 2016 Essential Training
Grouping by other factors
- In addition to Grouping data by Date in the Pivot Table you can also come up with your own Groupings. We're looking at a worksheet called OtherGrouping it's in our workbook called 14 - PivotTables. And we've got some data here and we got our Region broken out, Northeast, Northwest, Southeast, Southwest. And someone is asking us, "Can you come up with a Total for the East?" "Can we see this in the PivotTable?" Well, we don't really have any Eastern Region. We have the Northeast and the Southeast. First of all, let's put these together. Now, we don't need to highlight this data here if we want to move it next to Northeast, all we need to do is to select its label and then drag the bottom edge leftward. And the numbers below that, the 284, the 214, and so on will follow this as I drag just that Cell that contains the SE. Drag it over here to the left, let go of the left mouse button. And now they're adjacent to one another. We can highlight these two Cells right here, the NE and the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.