Cognos - Column title for crosstab rows

For the example show, let us bring column titile for the crosstab node 'Product Line' and 'Product'

Click the crosstab corner 'Quantity' and then make box type to none in properties pane.

Now pull a 'crosstab space' and drop along the product line and crosstab columns as shown (marked in red)

Cognos - Difference between 'Aggregate Function' and 'Rollup Aggregate Function'

The 'Aggregate Function' is used to rollup the values when "Auto Group & Summarize" is set to yes for the query, it applies some logic depending on the datatype. The 'Rollup Aggregate Function' is used for summary values like totals in the report

For example:

Fred       $5
Fred       $15
Barney   $20
Barney   $30

Put both columns on your report,
Aggregate function tells Cognos what to do with them with each other, ie.if you specify Total, this will show...

'Aggragate function'-Total
Fred     $20
Barney $50

'Aggragate fuction'-Average
Fred     $10
Barney $25

'Rollup Aggragate Function' tells Cognos what to do when you want a "Rollup" at the end of the Report or a Grouping (usually a Total or Subtotal, but could be any of the functions.)
So, if Aggregate is set to Total and Rollup is set to Total you get this...
Fred        $20
Barney    $50
Summary $70

If Aggregate is set to Total and Rollup is set to Average you get this...
Fred $20
Barney $50
Smmary $35

Cognos - Ungroup data in crosstab

Create a new data item(product&color) as Product||Color

Now place this data item in place of product. Then unlock report studio using lock/unclock button in top tool bar.

Then select the text item of this data item/node(please make sure only text item is selected not the complete node). And in the properties pane-> change the data source property to Product data item instead of product&color.

The output will be as:

A  WHITE 10
A  RED      3
B  BLUE    8