Hello,
I have a table which I am trying to add a Year Over Year calculations by calendar week.
Product_ID |
Week |
Year |
Revenue |
RevenueYOY |
1 |
50
|
2021 |
4.61 |
|
1 |
51 |
2021 |
5.80
|
|
1 |
50 |
2022 |
4.29 |
|
1 |
51 |
2022 |
2.98 |
|
Basically in the RevenueYOY column for week 50, year 2022 I would like it to display 4.61, and for week 51, year 2022 I would like it to display 5.80.
I have tried various set analysis functions, but am struggling to find a solution that works.
Any help would be greatly appreciated .