Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Grouping By Date in Pivot Table | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
grouping data in a pivot table | Excel Discussion (Misc queries) |