Sounds like your problem is that the data is in two places.
Possible solutions:
a) Make 2 Pivot Tables for the two chunks of data. Use GetPivotData formulas to extract the values for the matching items (eg by product code) and subtract them.
b) Carry some of the data across from one sheet to the other using eg VLOOKUP to fetch the starting inventory figure across to your sales table, but only for the first occurence of a product being sold. Include this extra column in your sales pivot and add a calculated field to subtract them.
I prefer (a) but you would have to do some prep to create a list of unique product codes (paste sales + inventory together and remove duplicates then sort) so you can point the GPD functions at those cells.
THanks but not looking that. – Gok Demir – 2010-02-05T15:56:53.327
Eh? (Do you mean "this won't work for me"? If so, why not?) – Martha – 2010-02-05T16:22:10.740