I need to create a report from my invoices. Each invoice is assigned to a sales lead. I need a report that list each lead and the sales generated. The catch is that I would like a total number for each product, the product name, and the total price for that product. The report may be generated for 5 invoices or 1000.
Example: (this may be the result of 40 different invoices)
Sales Lead "Trade Shows"
25 Software X $12,500
10 Software Y $ 5,000
15 Software Z $ 5,235
Total $22,735
Sales Lead "Direct Mailing"
17 Software X $ 8,500
5 Software Y $ 2,500
10 Software Z $ 3,490
Total $14,490
Etc...
Thanks to any and all that may be able to help. Mike