PivotTable-How to take difference between groupings of data
Posted by Jim on January 11, 2001 1:54 PM
I am trying to create an Income Statement PivotTable. In the row field of my PivotTable, I have several groupings of General Ledger account numbers. A group called 'Net Sales' is made up of 100 Sales accounts. A group called 'Cost of Sales' is made up of 80 Cost of Goods Sold accounts. The next grouping starts at the next line. I need to insert a line before that next grouping called 'Gross Profit' that subtracts the total of 'Cost of Sales' group from the total of 'Net Sales' group. I am having problems. Anyone know how to do this or a work around. Thanks.