How to Use Advanced Report Filters in Salesforce
Once you’ve got the hang of using the filters, you can begin to use the advanced filters which are able to filter by more than one field.
The search results are filtered by your selected criteria. By default, records must meet every condition listed. This means that your search criteria cannot conflict with each other.
You can always edit your filter logic to search for other records.
A new Filter Logic field appears, which shows how each of the conditions are being evaluated.
It's easy to edit and remove filter criteria.
You can also click Remove to remove the criteria altogether.
Salesforce updates the report filter.
You can also filter by adding any field to the Filter area.
The report will only display records that include the fields you specified.