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