Print Page - Is it possible to display Characters in Cross tab report instead of Numbers..

Title: Is it possible to display Characters in Cross tab report instead of Numbers..
Post by: rajua99 on 27 Jan 2020 09:29:25 AM

Hello,

I have a requirement where i need to display 'Y' when there is a value 1 in the Cross tab or 'N' when there is no value. attached is screen shot from the report. Is there a way to format the measure object to Display as Y or N depending on the value in the measure..

Thanks,
Raju

Title: Re: Is it possible to display Characters in Cross tab report instead of Numbers..
Post by: MFGF on 27 Jan 2020 03:45:00 PM

Quote from: rajua99 on 27 Jan 2020 09:29:25 AM
Hello,

I have a requirement where i need to display 'Y' when there is a value 1 in the Cross tab or 'N' when there is no value. attached is screen shot from the report. Is there a way to format the measure object to Display as Y or N depending on the value in the measure..

Thanks,
Raju

Hi,

The way I would do this is to select the crosstab fact cells, and define a conditional format for the cells containing a 1. Repeat for the others where the cells are empty (or use the Value if Null formatting option)

Cheers!

MF.

Title: Re: Is it possible to display Characters in Cross tab report instead of Numbers..
Post by: rajua99 on 29 Jan 2020 09:36:47 AM

Thank you MF. It worked.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: rajua99 on 27 Jan 2020 09:29:25 AM