I have a pivot table, which has dates as one of the fields. I have grouped these dates, by month and also by quaters.

Is there a way that when dates are grouped by quarters, you can select which month is included in which quarter.

Excel defaults that January, February, March are Quater 1, April, May, June are Quarter 2 and so on.

I want August, September, October as Quarter 1, November, December, January as Quarter 2 and so on.

My data is coming from an Oracle database, so I can't do anything with the source data, unless I use a decode function within the SQL query.

Anyone have any ideas?