1. User Guide
  2. Measure Filtering
  3. Combination of Various Filters
  4. Measure Filters and Position Filters

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

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.