hi,

have a pivot table that gives a bank statement:

1-apr opening bal 5000 dr
2-apr withdrew cash 2000 cr
3-apr chq to creditor 1000 cr

how do i get a new line automatically in the pivot:

1-apr opening bal 5000 dr
2-apr withdrew cash 2000 cr
3-apr chq to creditor 1000 cr
30-apr closing bal 2000 dr (that is total debits - total credits for
THIS MONTH OF APR ONLY)

how do i get the above last row automatically in a pivot, without
having it in source data, something like a calculated item or
something ? is it possible ?

best regards,
shripal d.