COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Kindness on 27 Jul 2011 02:48:59 AM

Title: how to display textual measure in crosstab?
Post by: Kindness on 27 Jul 2011 02:48:59 AM
Hi, everyone!

Does enybody know how to display textual measure in crosstab?
Title: Re: how to display textual measure in crosstab?
Post by: Lynn on 27 Jul 2011 07:13:28 AM
If you search you can find previous posts on this. Measures in a crosstab need to be numeric. You can, however, unlock the report and drag in text items to conditionally render them based on some rule related to the value of the measure.

This generally makes sense if you want a small, known, and fixed set of text labels instead of numbers. For example: High, Medium or Low based on a range instead of the absolute figure; Yes or No; Letter grade A, B, C, etc instead of a score; etc.

I would generally prefer a conditional style to control the display or suppression of the various labels, but it can be done with render variables as well.

Title: Re: how to display textual measure in crosstab?
Post by: Kindness on 27 Jul 2011 08:16:58 AM
thanks a lot!