19 Replies Latest reply: Dec 20, 2016 2:16 AM by Mohammad Adnan Ansari RSS

    Last Year Same Day Sales

    Mohammad Adnan Ansari

      I am trying to create a table with the below information:

       

      Date, Sales, Sales (Last Year Same Day)

      01/12/2016, 50, 21

      02/12/2016, 23, 21

      ..

      ..

       

       

      for Sales (Last Year Same Day) I am trying the below formula:

       

      Sum(

      {<

      [Date]={$=(Max([Date])-364)}

      >}

      Sales

      )

       

      This is just bringing '0'. I tried lot of options but it don't work at all.

       

      Any help?