I had a similar challenge. What I did was add a column to the data table
for the fiscal year and then group the pivot table by FY and Month.

Carlos


"Edgar Thoemmes" wrote in message
...
I have a pivot table with dates for the column headings. I have grouped
these
by month and year but this does not give me the desirable effect. At the
moment the dates are grouped as follows:

2003 2004
Jan Feb Mar Apr Jun..... Jan Feb Mar Apr Jun

I need to group these by FY so it would like:

Last FY YTD
Mar Apr May Jun.... Mar Apr May Jun

I tried adding an extra field for mm-yy but ended up confusing myself even
more....can some help?

I am using Excel 97.

TIA