Hello
Does anyone know if it is possible to display non numeric data/text only data correctly in the measure section of a Crosstab ?
Thanks
Moises

Sent from my iPhone
#CognosAnalyticswithWatson

Hi Moises,

You can drag a text element (non-numeric data) in your crosstab:
You need to open the unlock page objects.
Drag a report expression in your crosstab.
Define the expression, for instance : 
if [Query1].[Quantity] < 2000000 then 'Small' else if [Query1].[Quantity] is null then 'No Data' else 'Large'


Hide the measure (click on the measure, Quantity in this case) by selecting Box Type = None

Then your report will be

Best regards,

------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------

I wrote about this a few years ago:

https://cognospaul.com/2014/10/20/quickie-aggregating-text-cognos-crosstab/

------------------------------
Paul Mendelson
------------------------------