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
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 (http://www.cognoise.com/community/index.php/topic,6945.0.html)