Drill or Expand Hierarchies in a Crosstabulation Table

You can perform these tasks on a crosstabulation table that is based on multidimensional data:
  • Click expand icon 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
    In the Hierarchy Level Year, the Member 2007 Has Been Expanded to Display Values for the Quarter Hierarchy Level
  • Click drill icon 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
    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 In the Hierarchy Level Year, the Member 2007 Has Been Drilled to Display Values for the Quarter Hierarchy Level, you would click on the hierarchy level Year.
  • Right-click a hierarchy level heading, and then select Collapse All.