Thanks Shin for looking into it.
Is it possible to show the x-axis as Aug to Sep instead of Jan to Dec?
My bad, i think i have given u an addition of 24 months and i don't think will not work out which is >12 rolling months lets fix it for <=12 months in parameter.
When parameter = 10 then I need to display Dec to Sep in x-axis.
When parameter = 6 then x-axis should change from Apr to Sep and so on..
Also i think window_avg will not suffice my req.. I just wanted to display same values as it is..
Not sure what do you mean by
" Aug to Sep instead of Jan to Dec?"
Jan do Dec is 12 months
Aug to Sep is 14 months with 2 months over-wrapping.
14 month with over-wrapping is Completely different functions.
I mean ...
Lets say Max(Order Date) is Sep 15 and parameter ranges from 1 to 12. When parameter 1=12 is selected then below grind should be displayed.
Parameter 1=Sep 15; 2=Aug 15; 3=Jul 15; 4= Jun 15 and so on...
When Parameter 2 is selected then Sep, Aug should be displayed.
When Parameter 3 is selected then Sep, Aug, Jul should be displayed.
When Parameter 5 is selected then Sep, Aug, Jul, Jun, May should be displayed.
When parameter 1=6 is selected then below grind should be displayed.
Lets say id Max(order date)=Jun 15 then below grid should be displayed when param=12
I hope it is clear now.