1 Reply Latest reply: Jul 9, 2013 2:06 AM by Tresesco B RSS

    Week Conversion by using Month or Year. ( Date filed is not avilable on source)

      Hi fouks,

       

      Could you please help me to week conversion by using month or year. Actully week & date is not matianed one retailer.  All the retailers has week conversion, We need to convert all retailes to one week level format. I attached the excel for source format.

       

      Thanks & Regards,

      Radha Krishna

       

       

       






























































































































      RETAILERSTOREYEARYEAR/MONTHMONTHMONTH NAMEUNIT SALES
      A120112011055MAY230
      B220112011066JUNE305
      A120112011077JULY330
      A120112011088AUGUST292
      A220112011099SEPTEMBER437
      B1201120111010OCTOBER411
      B1201120111111NOVEMBER589
      A1201120111212DECEMBER603
      C120122012011JANUARY523
      A120122012022FEBRUARY711
      C120122012033MARCH632
      C120122012044APRIL596