Troubleshooting
Problem
Data items that hold string values can not be used as measures in a crosstab, however sometime it is desireable to display text in the crosstab cells
Resolving The Problem
The attached report specification contains a crosstab report that displays either 'lots', 'little', 'OK' or an empty string in the crosstab cells depending on the value of the crosstab measure for that cell.
The method used to create this report was to add the measure as a nested data item under the columns, then change the Source Type property to Report Expression. After that define an expression that will calculate what text to show based on the value of the measure for that cell.
Do not add the measure to the crosstab corner or it will not work, it must be nested under the columns or rows. If you want to, you can set the Box Type property for the measure column header to None to hide it.
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m500000008d78AAA","label":"Reporting"}],"ARM Case Number":"TS014048841","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
05 September 2023
UID
swg21454433