Need help for String value for Cross tab Measures

[abhinadig]

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=1AllNRA0YGoetB3mro2OOZEn_rrCXmPwC

Please find above report format and table structure.

Thanks in advance

[BigChris]

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

[abhinadig]

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,

[abhinadig]

Hi,

I changed the table structure to accommodate this change.

Thanks,