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:
The new filter is added after the selected 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".