Grouping Dates in a Pivot table for years that are not calendar ye
 

I have a whole heap of data thet I would like to compare on an anual basis,
however my problem is that my year runs from 1 October to 30 September, I do
not seem to have the option to re-define my years in a pivot table. Is this
possible.

As an alternative I have grouped the information by quarter, for the first
three years and I would like the current year to be showing the data on a
monthly basis, I know this is possible and have done it once by accident by
cannot for the life of me recall how i did it.

Thanks in advance

Grouping Dates in a Pivot table for years that are not calendar ye
 

Hope this helps:
http://blogs.msdn.com/excel/archive/...20/506172.aspx
http://peltiertech.com/Excel/Pivots/pivottables.htm

Regards,
Ryan---

--
RyGuy


"Uno" wrote:

I have a whole heap of data thet I would like to compare on an anual basis,
however my problem is that my year runs from 1 October to 30 September, I do
not seem to have the option to re-define my years in a pivot table. Is this
possible.

As an alternative I have grouped the information by quarter, for the first
three years and I would like the current year to be showing the data on a
monthly basis, I know this is possible and have done it once by accident by
cannot for the life of me recall how i did it.

Thanks in advance