2 Replies Latest reply: Mar 9, 2016 9:17 AM by Sunny Talwar RSS

    Set and Sales Analyais between past and post for given week

    Durga Ravula

      Hi Guys,

       

      Looking for expression to derive some set and sales analysis results using slider as variable define.

      Here is what i am looiking for, its bit tricky when we pass the week 20152.

       

      Week         Sales      Stores

      201545       $70.00          E

      201546       $40.14          EP

      201547       $71.00          E

      201548       $57.74          EP

      201549       $87.00          E

      201550       $70.00          EP

      201551       $23.00          E

      201552       $60.00          EP

      201601       $44.89          E

      201602       $52.20          EP

      201603       $90.00          E

      201604       $30.44          EP

      201605       $80.70          E

      201606       $40.00          E

      201607       $58.00          EP

      201608       $60.00          E

      201609       $45.00          EP


      Stores       Avg 4Weeks Post

                                      Vs

                      Avg 2Weeks Previous By %


      E                               +7.8%      (sum(<week = 201552,20151,210550,201549">)   - sum(<week = "201602,201603">))

      EP                             +4.2%      (sum(<week = 201552,20151,210550,201549">)   - sum(<week = "201602,201603">))



      Basically user will select the week and using slider they will define the Avg number of weeks for Post and previous weeks separately, I need to compare the Stores performance by summing the sales between those weeks at given selected week .


          sum(<week = 201552,20151,210550,201549">)                  sum(<week = "201602,201603">)

      <--------------------------------------------------------------------------201601----------------------------------------------------------->


       


      Any idea much appreciated.


      Regards,