COGNOiSe.com - The IBM Cognos Community

Hi Team,

Need your support in this.

Have a requirement where need to show string values for cross tab measures.

https://drive.google.com/open?id=1s1NiVbx73eftM3I_2AtBHI4cr6eSsknm (https://drive.google.com/open?id=1s1NiVbx73eftM3I_2AtBHI4cr6eSsknm)

https://drive.google.com/open?id=1AllNRA0YGoetB3mro2OOZEn_rrCXmPwC (https://drive.google.com/open?id=1AllNRA0YGoetB3mro2OOZEn_rrCXmPwC)

Please find above report format and table structure.

Thanks in advance

I presume you've done an internet search for that already...

http://cognosknowhow.blogspot.com/2013/07/how-to-display-string-measure-in.html
https://www.cognoise.com/index.php?topic=23751.0
http://www.cognosonsteroids.com/2012/01/crosstab-with-non-numeric-fact.html

Hi Chris,

I have gone through all these materials available on net and tried also but no luck.

The measures what i am trying to show are numbers only except that they have '/' as a delimiter in between the values.

I also tried to split the value based on delimiter and tried inserting multiple measures but no luck.

Thanks,

Hi,

I changed the table structure to accommodate this change.

Thanks,