Global Business Analytics

Hi Cognos lovers,

today I was approached by a user asking: "How do I repeat the row headers in a crosstab ... so ungrouping it. I need this for filtering in Excel"

Good question!

Looking everywhere in the product ... no options to ungroup anywhere.

No answer in documentation, nor my preferred search-engine. ChatGPT invented options that are not in the product :-) ROTFL.

With the help of IBM Champions @Jens Bäumler  and @Paul Mendelson I figured out how to "ungroup" the crosstab header rows.

Add a running-count([query-item]) to your query.

Add that item to your crosstab as first element in the rows.

Then hide it.

Hope this helps someone.

regards,
Ralf

P.D. Still wondering why there is no button for this in the product. Would be a cool enhancement.

Within the report properties there is an option called 'Group repeating cells - export to Excel'.

This may achieve what you want without additional query items. 

Hi Cognos lovers,

today I was approached by a user asking: "How do I repeat the row headers in a crosstab ... so ungrouping it. I need this for filtering in Excel"

Good question!

Looking everywhere in the product ... no options to ungroup anywhere.

No answer in documentation, nor my preferred search-engine. ChatGPT invented options that are not in the product :-) ROTFL.

With the help of IBM Champions @Jens Bäumler  and @Paul Mendelson I figured out how to "ungroup" the crosstab header rows.

Add a running-count([query-item]) to your query.

Add that item to your crosstab as first element in the rows.

Then hide it.

Hope this helps someone.

regards,
Ralf

P.D. Still wondering why there is no button for this in the product. Would be a cool enhancement.