Expanding and collapsing hierarchies in crosstabs

You can expand hierarchies in a crosstab that displays data from an OLAP data source and view several levels of data at one time.

About this task

Complete the following steps to expand or collapse a crosstab hierarchy:

Procedure

  1. Open a crosstab that is using an OLAP data source.
  2. Click the plus icon in a cell to expand the hierarchy and view the levels of data.
  3. Click the minus icon in an expanded cell to collapse the hierarchy.