Filter on Metric dialog box

A view filter restricts the amount of data displayed on the report and provides you with a different view of the data. You must own the OLAP Services product to create a view filter. For more details, see About view filters.

Use the Filter on Metric dialog box to create a view filter on a selected metric based on a rank range of metric values or to define a condition that is based on any metric on your report. For example, a view filter on a rank range of metric values allows you to view analysis for the bottom 20 products in terms of profit margin. A view filter based on a condition allows you to view analysis such as employees with 10-20 years of tenure with the company.

For steps to create a view filter on a metric based on rank, see Creating a view filter on a rank range of metric values.
For steps to create a view filter on a metric based on a condition, see Creating a view filter on a percentage range of metric values.

This topic provides the steps to access the Filter on Metric dialog box and explains each option in the Filter on right-click menu. The options in the Filter on right-click menu are Clear, Top N, Add Condition, and Edit Condition. This topic does not provide steps to create a certain type of view filter.

Accessing the Filter on Metric dialog box

Run the report in Grid View.
Right-click a metric on the report, select Filter On, and then select one of the following:
- To create a view filter based on a rank range of metric values, select Top N.
- To create a view filter based on a condition, select Add Condition.
- The Filter On Metric dialog box opens.

Filter On options

When you right-click a metric and select Filter On, the menu displays different options depending on whether the selected metric already has a view filter or not. If the selected metric has prior filtering conditions applied on it, the following options are displayed:

Clear: Clears the existing filtering conditions for the selected metric.
Top N: Allows you to create a new view filter by defining a rank based on the selected metric. For steps, see Creating a view filter on a rank range of metric values.
Edit Condition: Displays the existing view filter condition and allows you to change the condition or add a new filtering condition.
Add Condition: Allows you to create a new view filter by defining a condition based on the selected metric. For steps, see Creating a view filter on a percentage range of metric values.