Hello!
I have such problem (cognos 8.2, Report Studio):
I have a crosstab like this
date1 date2 ... dateN
value1 comment1 value2 comment2 valueN commentN
-----------------------------------------------------------------
attrA Avalue1 Acomment1 Avalue2 Acomment2 ...AvalueN AcommentN
attrB Bvalue1 Bcomment1 Bvalue2 Bcomment2 ...BvalueN BcommentN
....
attrN Nvalue1 Ncomment1 Nvalue2 Ncomment2 ...NvalueN NcommentN
and I need to add a column to it.
Column should be like this:
Acomment1
Acomment2
for attrA - Acomment3...
...
AcommentN
Bcomment1
Bcomment2
for attrB - Bcomment...
...
BcommentN
and so on.
Thus I need to add a column to the crosstab, which cells have to contain all values from other cells of the corresponding
crosstab row and these values should be in the table form.
How can I do this?
Any help is appreciated!
Insert a Crosstab space on the COlumn Edge where you need these other values, then select the interection for the Crosstab Space and the row edges they pertain to. In the intersection properties, select Yes for the "Define Contents" property.
Insert that query item that pertains to this cell in the intersection's cell.
Your crosstab's row edge properties may need to be set to include the query items that are being added to the content and are not part of the natural edges or intersections of the crosstab.