Skip to main content
Topics#Reports & DashboardsAnthony Gonzales's Question
Anthony Gonzales asked in #Reports & Dashboards
Mar 22, 2018, 3:19 PM

How do you filter for Opportunities that contain at least two product families?

I am trying to create a report to show only opportunities that contain both of the following product families (GPS, GLS). The issues is that if I do a simple filter and choose both entities from the picklist, the report treats this as an OR statement and includes any opportunity as long as it has either of the two when all I want is ONLY opportunties that contain bookings in both categories. Is this possible? The other issues is that If I break it out with 2 filters one for only GPS and one for only GLS (using AND boolean logic), it returns nothing because GPS by definition cannot be GLS so either filter omits the other. HELP!

 

The end solution should only show opps that contain values in both categories.

 

How do you filter for Opportunities that contain at least two product families?
8 answers
Write an answer...
0/9000