Hi Chris,

Thanks for taking the time.

I am looking to do this with all saleable items. 500+ products. I am looking for a way to analyse all products at once. Any suggestions?

I added a screenshot of the Pivot View in Sales Reporting. You can group by date.

Thanks again Chris,

We can have the same product on multiple lines within a sales order. This was as close as I could get but it is still not totally accurate.

There was a product showing on 15 lines. when I investigate from the product view like you initially suggested there were only 6 sales. One of the sales had the same product on 10 lines.

a bit of background, we sell lights, we sometimes quote for large projects and utilise the section function on the quote. So we would have:

Section: "Window 1" in that section have 10 x product A.
Section: "Kitchen" in that section have 5 x product A.

this counts as 2 lines, but only 1 sale.

any further thoughts?

Hi Graeme - one more idea added above.

Thanks Chris,

This really helped me out. I appreciate your contribution.

Graeme