Drill or Expand Hierarchies in a Crosstabulation Table

You can perform these tasks on a crosstabulation table that is based on multidimensional data:

Click to expand a member of a hierarchy level. You see the values for the current member and the values for the next hierarchy level down for that member.

In the Hierarchy Level Year, the Member 2007 Has Been Expanded to Display Values for the Quarter Hierarchy Level
Click to drill a member of a hierarchy level. You see only the values for the next hierarchy level down for that member. Note that a bread crumb appears above the table when you drill down in a hierarchy. Use the bread crumb to move up a level in a hierarchy.

In the Hierarchy Level Year, the Member 2007 Has Been Drilled to Display Values for the Quarter Hierarchy Level
Right-click a hierarchy level heading, and then select Expand All. In the display here, you would click on the hierarchy level Quarter.
Right-click a hierarchy level heading, and then select Collapse All.