I always use an extra column in the original data to return my adjusted quarter
numbers. But it sounds like you can't do that.

Gary Brown wrote:

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?

--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=527081

--

Dave Peterson