Custom Report creation in Sage 100 ERP (in explorer?)

Hi there,

I searched and couldn't quite find what I was looking for.

I'm looking to create a report where I can select 60 or so specific customers from our database and be able to see the sales (to all or each of them) of 35 items from our catalogue from 2019-2023. I'd like to see the total $ sold of items.

I've been exploring explorer but I'm having serious trouble isolating the specific customers and specific items (as well as isolating the report to between 2019-2023).

If you have any advice or guidance on this I'd really appreciate it. Thank you for reading!