SAGE 50cloud

I need a report writing in SAGE 50cloud.
PRODUCTS AND SERVICES
REPORTS.
I want a report that does the following
Product sales by catagory 1 to 10
within a date range
Summarised with a total of the sales.
example: catogory 1 sales 1/1/2022 to 31/1/2022 £000???