how to have grouped total at the bottom of cognos list report

[tushar gaurav]

I have list report which contains three column i.e Product Line ,Product Type,Revenue.
The grouping is done on Product Line and  aggregation total is applied on Revenue.
By default the generated html op should be as shown in sheet 'Cognos Default' in  excel 'Cognos OP' as attached,i.e at the end of each product line.
Is there any way that we can do it at the end of the list report i.e as shown in sheet 'Cognos Required' in the same excel attached. 

[AnalyticsWithJay]

There isn't an option for this by default but you could certainly recreate something like this.

Unlock the report, and drag a 1 column table into the cell of each summary row. The number of rows for the table will equal the number of summaries you have.

Then, you'll drag the data item from each summary into the appropriate table cell. Make sure you "pick up" (including the CSS class property) the style and assign it to the appropriate table cell. This will ensure that your table cell looks like a summary list cell.

Finally, you'll need to set the padding on the cell containing the table to 0, and probably play around with the table borders to hide it within the cell.