Measure Filters and Position Filters
Apply a measure filter with a position filter to the view of a pivot table. You can apply a position filter over a measure filter to the view to bring down the number of positions and concentrate on the subsection of data. When you apply a measure filter over the position filter, then the position filter is removed and the measure filter is applied over all of the available positions.
Figure 17-12 Position Filter Applied Over a Measure Filter
![Position Filter Applied Over a Measure Filter Position Filter Applied Over a Measure Filter](img/fg17-12.jpg)
Note:
Ordering of various filters combination is as follows:
-
Special filters takes precedence over all of the filters.
-
The measure filter and attribute filters are applied over special filter with AND operators.
-
Position filtering overrides all other filters, as a temporary state that can be lifted with right-click context menu option, Remove Position Filter.