Display the sum of expense item amount values by category in a report

Display the sum of expense item amount values by category in a report

I created a form that is used to input expense items. The form has many fields but the ones of interest are Category (e.g., Office Rent, Internet, Computer Support, etc.), Date, and Amount. I need to create a report that will display the sum of each expense item by category for a particular date range. For instance, assume that the following records have been created:


Category
Date
Amount
Office Rent
1/1/2022
$900.00
Internet
1/15/2022
$75.00
Computer Support
1/31/2022
$120.00
Office Rent
2/1/2022
$900.00
Internet
2/15/2022
$75.00
Computer Support
2/28/2022
$60.00
Office Rent
3/1/2022
$900.00
Internet
3/15/2022
$75.00
Computer Support
3/31/2022
$150.00

If a date range of 1/1/2022 - 3/31/2022 is specified, I want the report to display the following:

Computer Support: $330.00
Internet: $225.00
Office Rent: $2700.00

I have not found a way to do this. Is it possible with the Zoho Forms reporting capability?

Thanks!