I want to show the last 6 quarters in a pivot table.
Is it possible to make this dynamic? So when I open the document now I see Q1 2011, Q4 2010, Q3 2010, Q2 2010, Q1 2010, Q4 2009 but when I open the same document next month I want to see: Q2 2011, Q1 2011, Q4 2010, Q3 2010, Q2 2010, Q1 2010
Check the attached document. The idea is that you have a master calendar with all fields related to dates, and Quarter being one of them, you can easily say you want to show sales starting n months ago.