Insert Items From Multiple Levels of a Dimension

Use selection-based sets to position one or more items from a dimension adjacent to each other in the crosstab for a mixed grain comparison.

For example, you can select items from a single dimension like the following in the source tree.

An example of inserting items from multiple levels of a dimension.

You can drag these items to the crosstab.

Before you begin

You can also nest items from the multiple levels of the same dimension.

Procedure

  1. In the source tree, expand the dimension to locate the items that you want to insert.
  2. Press Shift+click or Ctrl+click to select multiple items in a dimension and then drag them to the crosstab.

    A selection-based set appears in the crosstab.

Parent topic: Creating a Basic Analysis