Non-Numeric data in crosstab measure area

[Gopinath]

Hi,

Is it possible to add non-numeric data to crosstab measures area in Cognos 10.1?



Thanks,
Gopinath.M

[udaychow99]

Hi Gopi,

Yes, you can.

Steps:
1)Drag respective query items into rows and columns area
2)drag required measure into the measure area
3)right click on measure area and select 'select fact cells' option
4)Now you will get 'text source variable' option in properties pane
5)go to view,drag strin variable,add values
6)right click at text source variable ellipsis button and select that string variable which you created earlier
7)Now go to condition explorer, click on some value, now go to properties pane and enter the value you wish at text in text source property.Do this for all the values in condition explorer
8)save and run the report

let me know if any further assistane required.

[Gopinath]

Hi Uday,

Thanks for your suggestion. But, i don't have any measure in my report.

Ex. The report should display comments from each customer for each product.

Row: Product
Column: Customer
Intersection (Measures) : Commets

[udaychow99]

Hi Gopi,

can you provide the structure of query subjects which you are using.
If possible provide some sample records also so that i will be able to provide alternate solution. :)

[ajaykumar]

Hi,

I have the same requirement where in I need to display character value in a crosstab. Attached is an example of my requirement