Crosstab Sum that only adds some of the columns

[hem852]

Hi

We have a crosstab report which has a 'month/year' across the top for the previous 12 months and 5 facts down the left.

I want to add a column to the end of the crosstab which gives me a total for the 5 facts for the current calendar year to date.

Is there a way of adding a column to the right of the crosstab which adds the values in 'month/year' column where the year part of 'month/year' is equal to the year part of the current date?

Thank you in advance for any help / suggestions

Regards
John

[JGirl]

I've moved my post for a similar problem to a new one as I'm using Cognos 8 not CRN
http://www.cognoise.com/community/index.php/topic,6945.0.html