Changing the Filter Order

When you add a filter, by default the new filter is added after the currently selected filter. However, you can change the positions of the filters and the order in which they are applied.

Moving a filter below another filter sets up an OR relationship between the two filters (data is included in the results if it passes through either one of the filters).

Moving a filter before another filter changes the order in which the data passes through the filters.

To change filter locations:

  1. Select the filter you want to move by clicking on it, then hold the mouse button down.

  2. Drag the filter to the new location. The pointer changes to an arrow with the outline of a box. When you point to a valid location to move the filter (below or to the left or right of an existing filter), an insertion mark appears to let you know you are at a valid location.
    Filter example 5

  3. When the insertion mark is at the location for the filter, release the mouse button. The filter appears in its new location.

    Filter example 6

In this example, we have changed the location of the filter we added in Adding Additional Filters. Before we moved the filter, rows were included in the results only if both filter conditions were matched. After moving the filter, rows are included in the results if either condition is matched.

If you add several filters, you may have unwanted connections between filters. To remove these connections, see Changing connections between filters.