Defining multiple filter conditions
When you create a filter, you define at least one filter condition, but you can create as many filter conditions as you need to display relevant data. Each condition you add further narrows the scope of displayed data. For example, you can create a filter that returns rows where the customer’s credit rank is either A or B and whose open orders total between $250,000 and $500,000. Each additional condition introduces complexity to the filter. Make sure you design and test filters with multiple conditions carefully. If you have too many filters that narrow the scope of the report excessively, no data displays in the report, or report element.