
Each account may have opportunities for more than one cathegory.
1 resposta
I would try creating a required Application picklist for the Opportunity object, then create a new report type with Account as the primary object and Opportunity as the child object. The summary report would show Accounts summarized by Opportunity product application, so pumps could have Company X, Company Y and Company Z, and the window frames group could also have Company X and Company Z, etc.