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

    Show previous year sales

    Sami N



      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.