Sales comparison previous year
I made a database with the following tables:
Orders, Customers, Suppliers
I have a field Orders::TotalAmount that calculates the total amount per order and a summary field (Total of TotalAmount) and I need to create a report to display 2 years total amount orders per customer next to each other for comparison.
Can someone help me with that ?