Hi all,
I'm using Excel 2010. In my Pivot Table, I have a Month Column running from July 2012 (written Jul-12 in the Pivot) to June 2013. I need to insert a new Column (that will act as 1st Quarter) after the September 2012 Column and so on...the 2nd Quarter column appearing just after December 2012....
I tried the "Group" function by right clicking the months column but it is not doing what I'm after! Is it because Excel is having difficulty to interpret the months because it does not start as from January? If that is the case, is there a solution to this?
I basically want my columns in Pivot Table to appear as follows: Jul-12, Aug-12, Sep-12, Quarter 1, Oct-12, Nov-12, Dec-12, Quarter 2, and so on till the last Quarter after June 2013.
Thanks for helping!
Bookmarks