I have customized a Sales by Customer report to show the items purchased by each customer over a specific period of time, each item shows quantity, sale price, purchase price, revenue, etc.

The problem is it lists the items by transaction, so if a customer buys the same item 3 times in a 6month period, the item will list 3 separate times. I want it to consolidate the different transaction lines into one summed line.

Instead of 'Item A" listed 3 times with qty 5 and revenue $20 on each line, I want one line of Item A showing 15 total qty and the total revenue $60.