The title says it all. I have two pivot tables that I would like to show the change in quantity and price from one to the other. On this attached workbook, I would like to know the difference (in a math sense) between the values of price and quantity from Sheet 1 to Sheet 2 and for the format to be similar. Please let me know if I can do this. I've tried data consolidation but it's not formatted like a pivot table and there is no difference function.
Bookmarks