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