I have a one query show sales by month by payment method. I then created a crosstab query to summarize everything by month for each payment method. However, now I want to create a column comparing 2020 vs 2019 for each payment method. Below is an example:
Month Cash Sales 2020 Cash Sales 2019 Difference Credit Sales 2020 Credit Sales 2019 Difference January February
How would i get this so I can create a report?
Thank you for any suggestions.