5 Replies Latest reply: Jan 24, 2014 5:42 PM by Amir Yazdani RSS

    Same Day Last Week comparison

      I have a data set that looks like :

       

      Date                 Sales  ....    ....   .....

      1/20/2014          100

      1/19/2014          200

      1/18/2014          300

      1/17/2014           400

      1/16/2014          500

      1/15/2014          600

      1/14/2014          700

      1/13/2014          800  

      1/12/2014          900

       

      Trying to create a "Same Day Last Week Expression"

       

      Date                 Sales        Last Week

      1/20/2014          100               800

      1/19/2014          200               900

      1/18/2014          300

      1/17/2014           400

      1/16/2014          500

      1/15/2014          600

      1/14/2014          700

      1/13/2014          800  

      1/12/2014          900

       

      I can not get the Set analysis to work.(sum({$<date = {$(lw_date)}>} sales )

      I appreciate any help.