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
------------------------------
Original Message:
Sent: Wed April 13, 2022 08:57 AM
From: moises suarez
Subject: Crosstab report
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