View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary Brown
 
Posts: n/a
Default Pivot Table Grouping by Quarters


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