Sales CRM
Filter reports with opportunity fields and conditions
Combine standard CRM filters with up to ten typed conditions on active public opportunity fields.
Where to start
Sales → CRM reports → Saved reports → Edit → Filter the opportunities / Additional field conditions
Fields and options
- Access needed
- Sales CRM viewing access; report owner to save changes
- Permission and scope
- Sales CRM viewing access; report owner to save changes
Before you begin
Open the correct company workspace and confirm Sales CRM viewing access; report owner to save changes. Review the original record before following these steps. Open the relevant entry under the native Sales menu; the workspace tabs use shorter labels such as Deals, Reports, Relationships and Sales setup.
Follow these steps
- Choose standard filters for pipeline, stage, opportunity owner, currency, assigned territory, outcome, forecast category, archive state or opportunity-name text.
- Open Additional field conditions to add narrower rules. Choose a field, an appropriate comparison and its value.
- Choose All conditions when every condition must match, or Any condition when at least one may match.
- Use Has a value or Has no value for presence tests. These comparisons do not need a match value.
- Preview the report and inspect a matching group before saving. Remove conditions that no longer describe the question.
Check the result
Inspect the underlying records and check the selected fields against the conditions. Test a narrower date or owner filter to confirm the intended population before widening it.
If something does not look right
Selecting a stage from another pipeline produces no matches when both filters are applied; choose a compatible pair. A zero result with several filters may be correct because filters combine rather than replace one another. An unavailable-field error requires editing the report to remove or replace that field; it does not grant permission to see restricted values.
Fields, rules and limits
- All standard filters apply together. Additional conditions are then applied using their selected All or Any mode.
- Only active public opportunity fields may be used in additional conditions. Administrator-only fields are excluded even when an administrator designs the report.
- A retired or newly restricted field makes the complete saved report unavailable, including an Any rule that also contains another valid condition. This prevents a hidden condition from leaking data through counts.
- Text comparisons ignore letter case and preserve accents. Contains treats its input as literal text. Numeric comparisons support up to four decimal places; dates use calendar dates.
- Missing or empty values match presence tests and do not match ordinary Equals, Does not equal, Contains or range comparisons.
- Opportunity owner filters apply to the linked opportunity even in an activity report. Grouping activities by Owner uses the activity owner.
- Assigned territory is the saved classification on an opportunity; it is not a fresh evaluation of every territory rule.
Related technical reference: Britixo's detailed product guide (opens in a new tab). The screens available to you depend on your configured modules, company and permissions.
Useful next steps
- Understand the Sales CRM workspace
- Create and preview saved CRM reports
- Choose report measures and date periods correctly
Contact the Proplix team if you need help with your setup. Include the page or record reference and a description of the issue; leave passwords and private access tokens out of the message.