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

2. Drag and drop Internet Sales Amount to the Data area, Customer
Geography hierarchy to Rows, and Ship Date Calendar hierarchy to
Columns.
3. You will see all the countries in the Customer Geography hierarchy in
your pivot table. Assume you want to group the countries within the
same continent. Multi-select France, Germany, and United Kingdom
countries by holding the Ctrl key and selecting the members with the
mouse. In the Pivot Table window select Pivot Table → Group and
Show Detail → Group as shown in Figure 15-24 . You can also group
the members on a hierarchy by selecting the members, right click,
and then select Group and Show Detail → Group.
Figure 15-24
4. The members France, Germany, and United Kingdom will be
grouped together under a new member called Group 1 as shown in
Figure 15-25 . Sub Total for the member Group 1 is also created with-
in the pivot table. Select members Canada and United States and
Group them. You will now see countries Canada and United States
are grouped under a member called Group 2. Australia is under a
member called Other.