Cross-tab chart with modified total

[crystaldev1]

I'm using CR 9 and SQL Server 2005. I have a cross-tab report with year columns and months of current year. For ex,

2007 2008 January February March

10 5 7 3 5

This cross-tab shows the total count for each year and for each month if it falls in current year. I would like the grand total at the end to only total current year (sum total count of months). Currently, it's totaling everything.

The formula I'm using for the columns is:

If Year({Object.date}) = Year({?@EndDate})
then Left(MonthName(Month({Object.date})),3)
else tr(Year({Object.date}),0,"")

Thanks.

 

[crystaldev1]

I found solution by searching for it in this forum. The only issue is I would like to suppress the total columns for previous years only. Right now it's displaying as follows:

2004 2005 2006
2004 Total 2005 Total Jan Feb March Total

5 5 7 7 1 3 6 10

I know you can suppress the column headers but I would like to suppress the column totals entirely for previous years. Thanks.