I have a list of data set. One column has the date which is broken down over a period of one year (i.e - 1/13/2013, 3/4/2013, 5/12/2013, 7/13/2013, 9/12/2013, 11/10/2013 and so on..... Is there a way to group the date by Quarter in my Pivot table. I want the quarter option to show but don't know how to do this. I only see the individual date coming up but want it grouped by quarter. This way I get to group revenue by quarter rather than the individualized date by revenue.

Any help much appreciated.

Thanks