Hi, 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 ther is no subtraction. How could I do that? I am using Excel 2007. Thanks