I have a table of data that has an amount field that is always positive and then a debit_credit_flag that contains a "d" or "c" depending on whether it is a debit or a credit. I want to create a pivot table that summarizes the debits and credits and has a total field of credit minus debit. How can I get the "credit - debit" calculated field into the pivot table?
Thanks,
Jeremy
Bookmarks