3 Replies Latest reply on Jul 31, 2018 7:21 AM by Zhouyi Zhang

    Show previous year sales

    Sami N

      Hi

       

      I would like to have a calculated field to hold the previous year sales for the particular  row

      i tried using lookup but it does not work.

       

      is there any idea to calculate the last year sales for a order date

       

      for eg

      Order date       PY sales   current sales

      30/07/2018         200        150

      12/04/2018      200            120

       

       

      the PY sales should look at the date 1 year back.

       

      Thanks

      Sami