Extended Grouping Analysis in Excel

Extended Grouping Analysis in Excel (Video transcript)

In the last lecture, we have grouped data by date in our pivot tables. We can also see some other ways to group our data.

Say for example we want to group these two regions to one, North region and this one to be South region. To do that select the two regions and right-click and then group. Now we have grouped and change the name to North. In the same manner, select this tow region and right-click and group and change the name to South.

Now we can collapse to the compact form of our grouping. And we can play with other analyses. we can group also rows if need to.

So we can make our own grouping with any data.