Create Measure Filters

Perform the following steps to create a measure filter on the selected measure.

1. Select the measure header and then select the Add Measure Filters option from the right-click context menu.

   Figure 17-1 Add Measure Filter

   

2. From the Measure filter dialog box, select Condition from the list and enter the value for which you need to apply a filter. The dimension and level are selected by default if you have a single level selected on the view.

   Figure 17-2 Apply Condition

   

   Note:

   If you have multiple levels selected for position dimension, then you can select the dimension level from the list.

3. You can see the filter results with the position matching the filter condition. In Figure 17-3, you can see the measure filter result applied on the Ly Sales R measure. The filter icon shows that the filter is applied on the measure column.

   The result shows the position where Ly Sales R is greater than 50,000.00.

   Figure 17-3 Measure Filter Result