Hi partner,
Please create such a report.
Primary record type is Product, Related record type is Opportunity Lines (Existing Product).
Add a condition in Opportunity Line. Filter the related entity Opportunity, set Status Equals Open.
Add Name of Product as a group head, and Opportunity of Opportunity Line as a column.
The report runs as follows.
Each group is a product, and there is no duplication between products, each product will only appear once, and the opportunities associated with the product are presented as a row of records under the product.
