11/06/2026
Why can't Salesforce just let me filter on TWO objects with an OR condition?" π©
That's a question we keep seeing pop up across Salesforce communities β and it's more common than you'd think.
Here's the situation: you want a report showing Opportunities that EITHER have Product A OR are tagged with a specific account type. Simple ask, right?
Except Salesforce's native cross-filter logic doesn't support OR between filters the way you'd expect. So teams end up:
β Building 2-3 separate reports and manually combining them
β Exporting data to Google Sheets daily just to run the comparison
β Hitting the 2,000-row report limit and wondering why their dashboard "looks wrong"
β Duct-taping Looker Studio or Power BI on top, just to ask one question
None of this is a Salesforce "flaw" it's a sign the system was set up to handle simple, single-object reporting, not the real cross-functional questions your business actually needs answered.
The fix isn't another workaround. It's:
β
Designing report types and custom objects with cross-filtering needs in mind from day one
β
Using formula fields or junction objects to pre-structure data for the questions you'll actually ask
β
Leveraging tools like Reports & Dashboards properly β or layering in a BI tool the right way, not as a band-aid
This is exactly the kind of thing that gets missed in a rushed implementation β and exactly what we fix when we come in to optimize a Salesforce org.
If your team is exporting to spreadsheets just to answer basic questions, your Salesforce setup is working against you, not for you.
