Analyzing Cubes using Office Client Components - Professional SQL Server Analysis Services 2005 with MDX - page 804

Figure 15-27
You can create a custom group of existing groups. For example you can
group Europe and North America as Northern Hemisphere. Hence Grouping
in Excel provides you the flexibility to do multiple levels of grouping which is
really useful when there are several members in a hierarchy and you want to
perform data analysis by grouping the members into several groups. You can
ungroup a group of members by right-clicking on the group name and select-
ing Group and Show Detail → Ungroup.
It is important to know the limitations of grouping hierarchy members in Excel
Pivot tables. You cannot group members of a parent-child hierarchy and hier-
archies of ROLAP dimension using Excel Pivot tables. Having learnt to use
various options in the pivot table for data analysis you will learn to present the
data to end users as formatted reports in the next section.
Formatting Your Pivot Table Report
The Pivot table is one of the report formats in which data is shown to the end
users. As with any reporting tool, you need the ability to format the report
based on end-users' needs. The Pivot table provides you several formatting
options; principally, you have the ability to format individual cell values in the
data, row, or column areas because these are just cells in an Excel spread
sheet. You have been analyzing the sales amount and you have not seen any