function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Christopher_JChristopher_J 

Query/Report on Opportunity Line Items where *another* product also exists on the opportunity.

Hi Experts,

 

I'm trying to sort this one out.  Basically I'm able to both sum, query, and report the total price of line items with a certain product name, but I'd now like to filter that list by whether or not a different product is also a line item in the opportunity.  I'm not seeing an easy way to do it in reports on SOQL.  A nested query maybe?

 

Any ideas?

Sonam_SFDCSonam_SFDC
If I understand your reqirement correctly - you can create a summary or martix report using Report Type: Opportunities with Product and summarize the records as per opportunity - this will show you opportunities which contain more than one product and the expected revenue.