1 Reply Latest reply: Mar 1, 2011 10:12 AM by Miguel Angel Baeyens de Arce RSS

    show last 6 quarters

      Hi,

      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

      Can anyone help me with this issue?