To filter data by measure

Procedure

You have the following options to open the filter dialog:
- Select a cell belonging to a dimension in the crosstab and choose Filter Filter by Measure Edit .
  If you select this option, the filter is applied to the members of the selected dimension.
- Select a cell belonging to a measure in the crosstab and choose Filter Filter by Measure All Dimensions Independantly Edit .
  If you select this option, the filter is applied to all dimensions in the analysis, from the outermost to the most detailed one. For example, in an analysis with three dimensions in columns A, B and C, the filter is first applied to the dimension in column A, then to the dimension in column B and finally to the dimension in column C.
- Select a cell belonging to a measure in the crosstab and choose Filter Filter by Measure Most Detailed Dimension in Rows Edit .
  If you select this option, the filter is applied to the most detailed dimension of the rows. For example, in an analysis with three dimensions in columns A, B and C, the filter is applied to the dimension in column C. This option is optimized for threshold value filtering.
- Select a cell belonging to a measure in the crosstab and choose Filter Filter by Measure Most Detailed Dimension in Columns Edit .
  If you select this option, the filter is applied to the most detailed dimension of the columns. For example, in an analysis with three dimensions in rows 2, 3and 4, the filter is applied to the dimension in row 4. As with the option above, this option is also recommended for threshold value filtering.
The Filter by Measure dialog box appears.
Note You can also open this dialog box using the context menu on the crosstab or the design panel.
In the Based on measure: list, select the measure you want to use.
In the Definition area, select the operator and value for a new rule.
The following operators are available: Between, Not Between, Greater Than, Greater Than or Equal to, Less Than, Less Than or Equal to, Equal to, Top N, Bottom N, Top%, Bottom %, Top Sum, Bottom Sum.
Press Add.
The new rule is added to the Rules area.
If you define multiple rules, select the logic for the rules.
Select AND, if all rules should be applied simultaneously, or OR , if only one of the rules should be applied.
Press OK.

Results

The data in the worksheet is filtered according to your selection. The filter is saved with the workbook and is available to other users or in other sessions. You can also open and edit existing filters again.