I have to do a report about orders and order lines with this need : if a certain product is in an order then i i don't want to see this order in my report, even if there are other order lines.
I've tried to filter on the concerned product but as there are other order lines the order still appears.
Has someone an idea?
thank you very much for your help.
Create Report 1 from Opportunity Subject area with the following fields.
Filter: Product Name <> 'Your filtered product'
Create your main report and filter the Opportunity ID from the 1st report.