Add Filter Logic
- From the Lightning Experience report builder, click FILTERS | | Add Filter Logic.From the Salesforce Classic report builder, click Add | Filter Logic.
- Enter each filter line number, separated by a filter logic operator.For example, (1 AND 2) OR 3 finds records that match both Filter 1 and Filter 2, or Filter 3.Here’s a complete table of filter logic operators:OperatorDefinitionANDFinds records that match both values.1 AND 2ORFinds records that match either value.1 OR 2NOTFinds records that exclude values.For example, Filter 1 is Industry equals “Biotechnology”. You set filter logic as Not 1. Your report returns recordswhich aren’t equal to Biotechnology.
- Click Save.