Skip to main content

Sales CRM

Filter reports with opportunity fields and conditions

Combine standard CRM filters with up to ten typed conditions on active public opportunity fields.

Reviewed 13 November 20262 minute read5 steps

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

  1. Choose standard filters for pipeline, stage, opportunity owner, currency, assigned territory, outcome, forecast category, archive state or opportunity-name text.
  2. Open Additional field conditions to add narrower rules. Choose a field, an appropriate comparison and its value.
  3. Choose All conditions when every condition must match, or Any condition when at least one may match.
  4. Use Has a value or Has no value for presence tests. These comparisons do not need a match value.
  5. 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.

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.