Show TOC

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

Context

You can filter out one or multiple members directly using the context menu or drag and drop.

Procedure

  1. In the crosstab, select one cell for each member that you want to filter out.
    To select multiple members, hold down the Ctrl or Shift key as you select members.
  2. Choose Filter Other Members in the context menu.
    To filter out the selected members using drag and drop, select the border of the marked field(s) and drag them out of the crosstab.
    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 filtering to dimensions with and without hierarchies.