How to Add a Cross Filter in Salesforce Report

Most Salesforce reports show you what’s there. Cross filters show you what’s missing — and that’s where the real insights live.

Want to find contacts who have no open opportunities? Accounts with no activity in 90 days? Leads that were never followed up? Cross filters make all of that possible without writing a single line of code or building a custom formula field.

This guide walks you through exactly how to add a cross filter in Salesforce, step by step, plus the best use cases that will make your data work harder for you.

What Is a Cross Filter in Salesforce?

A cross filter lets you filter a report based on a related object — specifically whether a related record exists or does not exist.

Think of it as a yes/no check on a relationship. For example:

• Show me accounts with open cases
• Show me contacts without any logged activities
• Show me opportunities with no associated quotes

Standard filters look at fields on the primary object. Cross filters look at the existence of related records. That distinction makes them incredibly powerful for spotting gaps in your pipeline, coverage, or follow-up process.

According to Salesforce’s own research, organizations that use advanced reporting features like cross filters reduce manual data cleanup time by up to 40%, simply because they can identify bad data patterns faster.

When Should You Use a Cross Filter?

Cross filters shine when you need to answer questions like:

• Which accounts have no contacts linked?
• Which leads have never received an email?
• Which opportunities are missing a next step or activity?
• Which campaigns have no members?

These are pipeline hygiene questions. And if you’re running any kind of outbound motion — whether cold email, LinkedIn prospecting, or cold calling — messy pipeline data is directly costing you revenue. Studies show that bad data costs businesses an average of $12.9 million per year (Gartner). Cross filters are one of the fastest tools in Salesforce to start cleaning that up.

How to Add a Cross Filter in Salesforce Report

Step One: Open or Create Your Report

Navigate to the Reports tab in Salesforce. Either open an existing report or click New Report to start fresh.

Cross filters work on reports with related objects — so make sure you’re using a report type that has at least one related object available (e.g., Accounts with Contacts, Opportunities with Activities).

Step Two: Enter Edit Mode

Once you’re in your report, click the Edit button in the top-right corner to open the report builder.

If you’re in Lightning Experience (which most teams are by now — Salesforce reports that over 85% of active orgs have fully migrated to Lightning), the interface will be the drag-and-drop Lightning Report Builder.

Step Three: Open the Filters Panel

On the left-hand side of the report builder, locate the Filters panel. Click on it to expand your filtering options.

You’ll see your existing filters listed here — things like record owner, date range, or stage. This is where you’ll add your cross filter.

Step Four: Click “Add Cross Filter”

At the bottom of the Filters panel, look for the Add Cross Filter option. It may appear as a dropdown under “Add Filter” or as a separate button depending on your Salesforce version.

Click it to open the cross filter configuration window.

Step Five: Configure Your Cross Filter

You’ll now see three key settings to define:

Primary Object Relationship Select the related object you want to filter on. For example, if your report is based on Accounts, you might choose “Contacts,” “Opportunities,” or “Cases.”

With or Without Choose whether you want records with the related object (records that have at least one match) or without it (records that have no match). This is the core logic of a cross filter.

Sub-filters (Optional) You can add sub-filters to narrow the related object further. For example, instead of “Accounts without Contacts,” you could do “Accounts without Contacts where Contact Status = Active.” Sub-filters give you surgical precision.

Step Six: Save and Run Your Report

Once your cross filter is configured, click Apply or Done, then Save & Run the report.

Your results will now reflect only the records that match — or don’t match — your cross filter criteria.

Adding Multiple Cross Filters

You’re not limited to one. Salesforce allows you to stack up to three cross filters per report, which lets you build compound logic like:

• Accounts without Contacts AND without Open Opportunities
• Leads with Activities AND without Converted status

Each cross filter operates with AND logic against the others by default. This layering is what separates a good report from a truly diagnostic one.

Cross Filter Use Cases That Actually Move the Needle

Finding Accounts With No Recent Activity

Add a cross filter: Accounts without Activities where Activity Date = Last 90 Days.

This surfaces your neglected accounts — the ones that are technically in Salesforce but haven’t been touched. For outbound teams, this list is gold.

Identifying Leads That Were Never Followed Up

Cross filter: Leads without Tasks or Emails.

Research from InsideSales.com shows that 50% of leads go to the first vendor who responds, yet the average response time is 42 hours. A report like this tells you exactly who fell through the cracks.

Spotting Opportunities With No Open Activities

Cross filter: Opportunities without Open Activities.

These are deals in your pipeline with no forward momentum. No next call scheduled, no email pending. According to Salesforce data, deals with consistent next steps are 2.5x more likely to close. This report helps you find which deals are stalling before it’s too late.

Accounts With No Linked Contacts

Cross filter: Accounts without Contacts.

If you’re doing any account-based outreach — LinkedIn outbound, cold email, or calling — an account with no contacts is an account you can’t reach. This report gives you an immediate cleanup list.

Common Mistakes to Avoid

Using the wrong report type Cross filters only work when the related object is available in your report type. If you don’t see the option to add a cross filter, check your report type first.

Forgetting sub-filters A cross filter without sub-filters can be too broad. “Accounts without Activities” might look alarming until you realize it includes brand-new accounts added yesterday. Sub-filters let you add date ranges and status conditions to make the data meaningful.

Confusing cross filters with row-level filters A row-level filter looks at a field on the primary object. A cross filter looks at the existence of a related record. They work together — don’t replace one with the other.

Not scheduling the report If you’re building a report to track pipeline hygiene on an ongoing basis, schedule it to run automatically and email results to relevant people. A report that never gets looked at doesn’t fix anything.

Cross Filters vs. Standard Filters: Quick Comparison