Using the Level tool

When a dimension has a hierarchy defined for it, use the Level tool to select all the values at one or more levels of the hierarchy. For example, to analyze Sales data by city, you might select all the Geography dimension values at the City level. To analyze monthly and quarterly Sales data, you might select all the Time values at the Month and Quarter levels.

To select values using the Level tool:
  1. In the Selector dialog box, choose the Level tool from the Selector toolbar.

  2. Complete the Select by Level dialog box.

  3. Choose OK.

See also

Selector toolbar