COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: sspk on 27 Feb 2008 11:30:27 AM

Title: cross tab report
Post by: sspk on 27 Feb 2008 11:30:27 AM
Hi All,
Can we add a query calculation(whose calculation is not equal to the cross tab measure cell ) to a cross tab report.How can this be done if possible
Title: Re: cross tab report
Post by: almeids on 27 Feb 2008 11:48:49 AM
You can not display more than one value in a crosstab cell.  However, you can create another level in your rows or columns dimension to include an additional measure in the crosstab.

Title: Re: cross tab report
Post by: sspk on 27 Feb 2008 12:18:44 PM
Quote from: almeids on 27 Feb 2008 11:48:49 AM
You can not display more than one value in a crosstab cell.  However, you can create another level in your rows or columns dimension to include an additional measure in the crosstab.


Thanks, can you tell me how to do that.
Title: Re: cross tab report
Post by: Suraj on 27 Feb 2008 01:25:18 PM
see the screenshot here for what almeids is explaining.
http://image58.webshots.com/658/8/29/11/2866829110073696702chjJCu_ph.jpg
Crosstab screenshot (http://image58.webshots.com/658/8/29/11/2866829110073696702chjJCu_ph.jpg)
Title: Re: cross tab report
Post by: raja on 13 Mar 2008 01:45:23 AM
Quote from: sspk on 27 Feb 2008 11:30:27 AM
Hi All,
Can we add a query calculation(whose calculation is not equal to the cross tab measure cell ) to a cross tab report.How can this be done if possible