Print Page - Adding columns and rows to a crosstab report

Title: Adding columns and rows to a crosstab report
Post by: kdobeng on 22 Jun 2011 10:55:40 AM

How can I add extra columns and rows to a crosstab report?
I have a column that contains two measures - an amount and a calculated % field. I need to add two columns at the end to contain the total amount for each column. I also need two extra rows at the bottom of the report for two calculted measures

Thanks

Title: Re: Adding columns and rows to a crosstab report
Post by: MFGF on 23 Jun 2011 02:53:29 AM

Drop Query Calculations from the Toolbox as new columns and new rows, and code the relevant expression in each to derive your required results.

Regards,

MF.

Title: Re: Adding columns and rows to a crosstab report
Post by: kdobeng on 29 Jun 2011 06:35:12 PM

Thanks :)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: kdobeng on 22 Jun 2011 10:55:40 AM