I’m working on a query at the moment and I want to compare the weekly revenue and customers with that of the previous year. Sounds straightforward, except that I want to compare weeks of the financial year (starts 01/04/2020) with last year. So essentially what I want the table to look like is something like this:
Week No. | FY 2020 Revenue | FY 2019 Revenue | Year on Year change |
The problem is I can’t seem to work out how to generate the week number of the financial year consistently - anyone done this previously or have any tips on where to start?