S
shripaldalal
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.
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.