I have one table of category headings and a second table of receipts (date, amount, vendor and a category pulled from the category table). I want a report that details each month and inside that each category and its totals only. So for example:
June 2020
Automotive $100
Telecoms $200
Rentals $300
Total $600
July 2020
Automotive $200
Telecoms $300
Rentals $400
Total $900
Grand Total $1500
To clarify, each category total per month is made up of a number of receipts in that month for that category.
I have played with the wizard for hours but cannot seem to get the right sequence. Any assistance GRATEFULLY appreciated!
David