There's nothing built into the pivot table that will allow you to group
dates by fiscal year. You could add a column to the source data, in
which you calculate the Fiscal year and month. Then, add that field to
the pivot table.

berby65 wrote:
When you group dates by year in a pivot table it is always by calendar years
i.e. January to December. This isn't very useful if your financial year runs
for example from March to February. Is there a way of customising the
grouping within a pivot table?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html