Hi all,
I am using the Sales by Product (summary) report located under Invoices and Credits. It gives the option to add date fields but the results on the report is the total sales over say 5 years - is there a way to break down the totals by year to display on the report. So for example:
2019 | Qty |
Mediascreen | 5 |
Speakers | 6 |
2020 | |
Mediascreen | 7 |
Speakers | 8 |
2021 | |
Mediascreen | 9 |
Speakers | 2 |
Then display grand totals at bottom of report? Is this do-able?
Thanks in advance for any help offered.