Report filters and filter logic
Key Takeaway
A record must match all field filters unless you add filter logic. Filter logic applies only to field filters.
Report filters narrow a report so it shows only the records you need, such as opportunities over $50,000 or accounts in California. Each field filter tests one field. Filter logic lets you combine numbered field filters with AND, OR and NOT, so you are not forced to require every filter to match.
Filter types
A report can use several filter types:
- Standard filters
- Field filters
- Filter logic
- Cross filters
- Row limit filters
Each type scopes the report data in a different way, so picking the right type is part of building the report. A report can have up to 20 custom filters.