6 Replies Latest reply: Sep 27, 2014 4:59 AM by Marco Wedel RSS

    replacing a Initial value by last value of last row

    balraj ahlawat

      Hello all,


      I am using a pivot table and I have to replace Initial Value by Last value of the previous row at front end?


      Any function?




      Date         Initial Value     Sales          ClosingValue

      Apr-14        50                   10                 60

      May-14        60                  30                 90

      June-14       90                  -20                70



      like this.......at front end