how to display textual measure in crosstab?

[Kindness]

Hi, everyone!

Does enybody know how to display textual measure in crosstab?

[Lynn]

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.

[Kindness]

thanks a lot!