Subtracting in a Pivot Table
Posted by Chris II on April 11, 2001 9:00 AM
I have a worksheet that queries a database file of financial information. The fields relevent to this question are the Obligations and TransactionType.
When there is an expenditure it is totaled under the Obligations and is represented by an L in TransactionType. When there is a credit it is totaled under the Obligations and is represented by an M in TransactionType. Both are positive values which is causing me problems in getting the total expeditures which would be Obligations of TransactionType L - Obligations of TransactionType M.
What I need to have is the TransactionType as a Column Heading in the Pivot Table and a column that is the difference or just a Total column that is the difference.