Databases Reference
In-Depth Information
Figure 15-16
The second option to analyze the data for Accessories and Bikes is to drag
and drop the Product Categories hierarchy to the rows adjacent to the Fiscal
Year. When you had Product categories in the Page Fields area the pivot
table showed the "All" members of the Product Categories hierarchy.
However, while dropping the product categories on rows you will see the first
level of the Product Categories hierarchy and its members will be visible in
the pivot table.
Figure 15-17
shows the results of the Pivot table.
Figure 15-17
Whenever there are multiple hierarchies in rows or columns, the Pivot table
creates an automatic grouping for each member in the hierarchy and creates
a subtotal. In
Figure 15-17
you can see a row showing the subtotal for each
year. Because you wanted to analyze the data for Accessories and Bikes, you
need to restrict the visible members. Select the drop-down list next to cat-
egory, deselect the Show All checkbox, and then select the members Ac-
Search WWH ::
Custom Search