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?

       

      Example:

       

      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

       

      Regards,

      Balraj