2 Replies Latest reply: Nov 12, 2012 4:26 AM by - - RSS

    How to add last row particular column data value to next row in the pivot table?

    Nirav Bhimani

      Hi Everyone,

       

      I want Pivot Table as following:

       

      TrasactionNo         Date             MainBalance      Dr      Cr      CurrentBalance

      1                          15-1-11             1000             100     -          900

      2                          16-1-11            900               100     -          800

      3                          16-1-11            800                -       500     1300

       

      In the above case my each CurrentBalance become the MainBalance for next column. 

       

      So please proivde me any solution for that.

       

      Thanks & Regads,

      Nirav Bhimani