For table calculations to work as expected,
one should have the necessary Dimension fields
somewhere on a view (Rows/Columns/Details/Pages).
The [Week Number] is absent on your 3w view,
it is on a Filter shelf only, and this is not enough.
Moreover, if you want to show only one [Week Number] on a view,
and you're calculating LOOKUP() along this field,
you have to use Table Calc filter -- to hide Marks
(but not Filter them out from a view completely).
Please find the attached w/Sheet 7 as an example.
Hope it could help.
3 Week Trend_YF.twbx 50.3 KB
Thanks a million Yuri!!
Your answer is just what I needed, you can't imagine how thankful I am!!
Best wishes to you and hopefully this thread will help someone else in the future too.
Arnau, you're welcome.