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

U

Uno

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
grouping dates in a pivot table 1
Pivot table grouping help 0
Value of the first day of a year in a list 5
weekday in pivot table 4
Extract Month and year from Cell containing date, month, year & time 2
Multiple Tables and Multiple Pivot Tables Help 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0

Top