Show TOC

To filter members directly on the crosstabLocate this document in the navigation structure

Context

You can filter for one or multiple members directly using the context menu or double-clicking a member cell.

Procedure

  1. In the crosstab, select one cell for each member that you want to filter for.
    To select multiple members, hold down the Ctrl or Shift key as you select members.
  2. Choose Filter Members in the context menu.
    Note To filter for one member only, you can also double-click the corresponding member cell.
    In the design panel, the filter icon is added to the corresponding dimension.

Results

The data in the worksheet is filtered according to your selection. You can apply this filter to dimensions with and without hierarchies.