If the returned data set is less than 65k rows you could use 'get
external data' to extract the rows into a worksheet, create a new date
column and then build your pivot table from that worksheet's data. Use
the 'adjacent column formula' functionality to auto poulate the column
value
Here the default financial year starts on 1 July.
Using this as an example, add an extra column to the data with a value
of the real date plus 184 days. Then 1 July 2005 becomes 1 Jan 2006 in
the new column. The when you group by the date in the new column "Year
2006 Q1" would include all transactions with an original date between
1 July 05 and 30 Sept 05. Depending on how the date arithmetic works
out you may need to add months rather than days.
If you can get a change done to the Oracle view you can use syntax like
(dateAcct + 184) AS QuarterDate .. or the month equivalent .. to create
the relevant values in a new column in the view and then hit the data
directly.
regards..
--
steven1001
------------------------------------------------------------------------
steven1001's Profile:
http://www.excelforum.com/member.php...o&userid=30757
View this thread:
http://www.excelforum.com/showthread...hreadid=527081