In this activity my formula is IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 . My result is 0, I don't know whether it is right or wrong. Can somebody please confirm this. Attaching the screenshot. Thank You very much.
@akssaju Look for the Forecast Year weeks. I guess it would be starting 1st week of FY20. You should be able to see values from FY20 1st week onwards and would be same as Volumes of 1st week of FY19 onwards.