Home » Questions » Computers [ Ask a new question ]

Excel Pivot Table Consolidation soing subtraction

Excel Pivot Table Consolidation soing subtraction

I have one sheet for products purchased and another one that sold. I want to make a pivot table from two sheet to get current inventory for each product. But options are only sum, average etc there is no subtraction. How could I do that? I am using Excel 2007. Thanks

Asked by: Guest | Views: 194
Total answers/comments: 0