Does anyone know anything about Pivot Tables? They are killing me. What I need to do I can do in 2 seconds in Excel but I need to get it to work in Access.
I've attached an image of the Pivot Table. All I need to do is add a calculated field that will give me the % Difference of volume from one period compared to the other period. In this case, I want the % Difference from 2010 compared to 2009.
I've also attached the Pivot Table from Excel. Please help.