Databases Reference
In-Depth Information
Figure 15-25
5. Click on the member Group 1 and rename it as Europe. Similarly re-
name Group 2 as North America and Other as Australia. Your pivot
table should look like
Figure 15-26
. You can see that the totals for
the groups are qualified by the new name you have provided.
Figure 15-26
Thus the grouping feature in Excel helps you to group members in a hier-
archy and define a group name that makes it easy to analyze the data. Since
the totals are created for the groups for the end user the group name will ap-
pear to be a level in the hierarchy which they can drill down or drill up. If you
click on the drop-down list for Customer Geography you can see the new
members created due to custom grouping along with the members in the
Country level as shown in
Figure 15-27
.
If you double-click on the group
member you will see that the double-click acts as a toggle switch to hide or
show details in the next level. For example if you double-click on Europe you
will see the members France, Germany, and United Kingdom are hidden if
they are visible and vice versa.
Search WWH ::
Custom Search