A view filter restricts the amount of data displayed on the report and provides you with a different view of the data. You can create a view filter based on a rank range of values, or by defining a condition that is based on any metric on your report. You must own the OLAP Services product to create a view filter. For more details, see the View Filters chapter in the OLAP Services Guide.
This topic provides details on each option in the Filter on Metric dialog box, and steps to access the dialog box. It does not provide specific steps to create a certain type of view filter.
For steps to create a view filter on a metric based on rank, see Creating a filter on metric based on rank..
For steps to create a view filter on a metric based on a condition, see Creating a filter on metric based on a condition.
Use the Filter on Metric dialog box to create a filter on a selected metric based on a rank range of metric values or on a condition. The view filter on a rank range of metric values lets you to view analysis such as the bottom 20 products in terms of profit margin while the view filter based on a condition lets you to view analysis such as employees between 30% and 60% of tenure length with the company.
Run the report in Grid View.
Right-click a metric on the report and select Filter On.
Select one of the following:
Top N to create a view filter based on a rank range of metric values.
Add Condition to create a view filter based on a condition.
The Filter On Metric dialog box opens.
The Filter On menu displays 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: Displays the Filter on Metric dialog box to create a new filter by defining a rank based on the selected metric. For steps, see Creating a filter on metric based on rank.
Edit Condition: Displays the Filter on Metric dialog box with the existing filter condition and lets you to change the condition or add a new filtering condition.
Add Condition: Displays the Filter on Metric dialog box to create a new filter by defining a condition based on the selected metric. For steps, see Creating a filter on metric based on a condition.