Need some help in creating a report which will provide all oppty which has product1 and product2 in their opportynity line item. Product 1 and Produc 2 will be an AND condition so that it only shows opportunity which has the two products only.
If any oppty has only product1 , it shouldnot show in the report and similarly if any oppty has product2 , it should not show in the report. The oppty which has both the products should be only returned in the report.
I used the report type as Opportunity with products
I tried to create two filters with product name contains 'Product1' and Product name contains 'Product2' but once I ran the report it returned nothing. This filter is not checking both the rows it checks against one row line item record.
Any idea how to proced in this scenario.