Each month I rack my sales by product. Currently I either have to run a separate report for each product (I have 7) or download the data into excel which is a royal pain in the but.
Instead of showing just the total sales count and the sales value, I'd like to also have a break down by project, seperating out sales from returns, i.e.,
Sales Refunds Value
-------- --------- -------
Product A 50 1 $4900
Product B 20 0 $2000
Product C 19 0 $1900
------------------------------------------------
Total 89 1 $8800
------------------------------------------------
Kevin Mcisaac