Rolling 52 weeks

[Shiva123]

hello,

          every one i have a typical scenario where in i have to create a variable for rolling 52 weeks (exactly a year ago ) using another  variable (which changes every week) so that i could limit my data for Rolling 52 weeks. First of all is this  the right way of liming data by using variable?  or is there any procedure, if so could you please let me know .

Thanks in advance

[Anil_Babu_Samineni · Accepted solution]

If you need exact 1 year back comparison you can use this?

Sum({<Year = {">=$(=AddYears(Max(Year), -1)) <=$(=Max(Year))"}>} Sales)

[rohitraut]

Hello Shiva,

Try this,

Rolling 52 Weeks:

=count({<Week={"<=$(=Week(max(Date)))  >= $(=Week(max(Date))-52)"}>}Date)

Hope this helps!

[mostwanted123]

Hi Shiva,

For Rolling 52 weeks,

Sum({<Date={">=$(=Week(max(Date))-52)<=$(=Week(max(Date)))"}>}Sales)

Regards,

Pratik Bhor