Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi ,
Try using above() function
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