crosstab report :display the value of column at "total" field

[bobby72]

Hi ,

I have a multiple column summary crosstab report in which I have columns as date field of my table. The one summary is based on month basis and other on the year basis. The year column comes after the months for a year. The year column has a "total" as the column heading which I would like to program for the year for which the column is.

the display I have a like this

2001 2002

1/2001 2/2001 3/2001 4/2001 total 1/2002...

$10.00 $20.00 $10.00 $15.00 $55.00 $10.00...

I want to replace the total with 2001, 2002 etc. for which the total it has.

2001 2002

1/2001 2/2001 3/2001 4/2001 (2001) 1/2002...

$10.00 $20.00 $10.00 $15.00 $55.00 $10.00...

Any help will be appreciated.

Thanks
bobby