I have a pivot table that has MM-YY in the columns. I want to be able to group the years as well as other months wihin the years. Can I do this?
For example, want to be able to see 2011, 2011 Jan-Apr, 2011 Jun-Sep; 2012, 2012 Jan-Apr, 2012 Jun-Sep. It seems that when I group the 2011 it doesn't allow me to regroup other dates.