Adding Additional Filters

After you have defined a filter, you can add additional filters to further refine your queries. By default, new filters are added to existing filters with AND pipes, so a second filter operates only on the data that passes through the first filter. For information on changing the AND relationship to an OR relationship, see Changing the Filter Order.

To add more filters:

  1. Select a filter by clicking on it. The new filter will be added after the filter you select.
  2. Double click on a column name whose data you want to filter, then define filter as before.

    The new filter is added after the selected filter.

  3. If you want to add additional filters, repeat the previous steps to select a location in the filter chain and define a new filter.

As an example, we have added a filter to the one created in Creating a Simple Filter to further refine our results. The first filter only selects rows whose LOCATION value is "Rockville, MD" The second filter selects rows from the results of the first filter whose SERVICE value is "Consulting".

Filter example 2