I was recently trying to create a report that would show me when two different products exist on the same deal. For example, if a deal was a grocery list, I want to report on how many deals have both bananas and oranges on them. My report was to show the sum of deal amounts with these two items and the average value of deals with these two items. The property criteria I tried to use was Line Item 'Name'. So if the deal has Line Item Name banana and line item name orange, then include that deal in the report. Surprisingly, you can't do this in the custom report builder. The builder uses both criteria to look at each line item individually and since a line item name can only have one value at a time, no dice. Contact lists do however allow this, so I have created a clunky workaround that uses list memership as a report criteria, but it's extra steps for something that should be out of the box in the report builder. Please fix. thanks
