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

grouping dates in a pivot table 1
Pivot Table Grouping 1
Grouping Date Data in a Pivot Table 1
grouping dates in pivot table: calculated field? 2
Grouping in pivot table 2
Grouping Years in a Pivot table 2
In Pivot table sort 1
calculating differences in a pivot table 3

Top