How to Use Filter Logic in Salesforce
·2 min read
In this article
Here's how to use filter logic in Salesforce
- Navigate to the Reports tab and either select an existing report or create a new one.
- Locate and click the filter icon positioned in the top-right corner of the report interface.
- Add your desired filters to the report before proceeding to configure the logic relationships.
- Click the Right Arrow icon to access the advanced filter logic configuration options.
- Select and configure your filter logic settings from the left panel, choosing between Group and Filter options.
- Build your logical expression using field references, AND/OR operators, and parentheses for complex conditions.
- Enable the 'Update Preview Automatically' toggle and click Run to test your filter logic.
- Review the results and when satisfied with the output, click Save to preserve your report configuration.
Ready to get started with
interactive demos?
Frequently Asked Questions
AND operators require all connected conditions to be true for a record to appear in results, while OR operators show records that meet any of the connected conditions. For example, 'Stage = Closed Won AND Amount > 10000' shows only high-value won opportunities, while 'Stage = Closed Won OR Stage = Negotiation' shows opportunities in either stage.
Salesforce