COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: dannyboy on 29 Sep 2008 11:00:41 PM

Title: Help needed with Crosstab calculation....please
Post by: dannyboy on 29 Sep 2008 11:00:41 PM
Hi guys,

I am struggling to create a calculation which looks at the year name in a report and calculates variances based on what year it is. If I had used a list, I think this would have been much easier but because of the data-setup I have been advised to stick to crosstabs. I have tried creating new data items but to no avail. Attached are what the report looks like in Report Studio - output reports are available if this would help

Any help would be much appreciated - as I dont post often here, Im not sure how much info to include so if any more is needed please let me know

Cheers,