hi,
i have bank transaction table like this
accno transactionid date balance credit-amt debit-amt
------------------------------------------------------------------------------------------------------
100 1 11/5/12 5000 - -
100 2 15/5/12 - 400 -
100 3 23/5/12 - - 200
100 4 24/5/12 - - 500
this is the table .what i need the out table(it means qlikview staight table) is like this
accno transactionid date balance credit-amt debit-amt bal_amt
--------------------------------------------------------------------------------------------------------
100 1 11/5/12 5000 - - 5000
100 2 15/5/12 - 400 - 5400
100 3 23/5/12 - - 200 5200
100 4 24/5/12 - - 500 4700
please help me as soon as possible.........
Thanks
vinodh c
