Year over Year calculation in table.

[AndrewAshdown]

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 .