Context
You can filter for one or multiple members directly using the context menu or double-clicking a
member cell.
Procedure
- 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.
- 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.