I am having a strange issue with a pivot table our finance people are trying to use. I have attached an example file which shows the problem.
Basically we are using a data sheet to populate a pivot table and show us change of sales information.
Sheet one holds the data for the pivot on sheet4. I have removed the 40,000 other rows which hold the rest of the data.
As you can see all the calculations in the pivot are working except for the last column, Q (2011 summary of change in units). This column is supposed to give us the difference between the unit sales in 2010 and 2011.
Instead of that result we seem to be getting the difference between 2010 $ sales and 2011 unit sales. We need the difference between 2010 unit sales and 2011 unit sales.
Can anyone see what the problem here is?
Thanks in advance.