Dynamic Week Numbers

[prasanth_nossam]

Hi All

we are trying to Achieve Dynamic last 7 week numbers. created this calculation its working

=aggr(if(rank(ShipWeek)<=7,ShipWeek),ShipWeek) but problem is  when week 52 (2017)and  week 1(2018) come. Above calculation fails in this situation 47,48,49,50,51,52,1.   shipweek colum is contains week numbers 1 to 52. please help

Regards

Prasanth

[Anil_Babu_Samineni]

First you need to manipulate code like Redefining the Week Numbers

[prasanth_nossam]

Hi Anil

Unfortunately we don' t have Date column.

We only have Shipweek column contains numbers 1to 52.

And shipmonth column contains 2017-10,2017-11,2017-12,2018-1. Like this