Context
You can filter out one or multiple members directly
using the context menu or drag and drop.
Procedure
- 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.
- 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.