Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
First you need to manipulate code like Redefining the Week Numbers
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