Need Help in scripting(Calculating 13 Weeks Sellout)
Hello Everyone,
Need help in calculating the cumulative sum of Prev13 weeks including current week, and we need to have this values next to each Week in the data..and this has to be done at script level.
It explains, in the script, how to populate an Asof table, which will be used to do the rolling cumultative datas, the YTD etc. it should answer to your question.
Thanks for your reply, but i want some thing like below.
say we have 30 weeks data , from 13th week we should sum up the Previous data(EX: 13th week 1-13 , 14th week 2-14 15th week 3-15..and so on). hope you understand my requirement. and i need to this in LOAD Script level not in report level.
