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

[Anonymous]

hi ,

          Try using above() function

[nirav_bhimani]

HI,

I want my current balance as a MainBalance in next row.

I have use the following set exp

=if(RowNo(TOTAL)='1'

          ,$(v_OpeningBal)

          ,(Above(Column(4))))

its working only for First four records which having same date, if date changes then its not showing any value.

Regads,

Nirav Bhimani