Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: NiceCube on 09 Feb 2018 06:25:55 AM

Title: Crosstab Grouping
Post by: NiceCube on 09 Feb 2018 06:25:55 AM
Hi,

OTH0118710778   OTH0118710778-G-01   OTH0118710778-1
OTH0118713380   OTH0118713380-G-01   OTH0118713380-1
OTH0118713380   OTH0118713380-G-01   OTH0118713380-2
OTH0118713380   OTH0118713380-G-01   OTH0118713380-3

I have a dataset (see above sample) that, when transposed and rendered as a crosstab, groups the data so that the values  OTH0118713380 and OTH0118713380-G-01 only appear once.

Is there a way the report can fill the values into all cells (the rpeort is output as xlxs)?

Thanks in advance,

Richard
Title: Re: Crosstab Grouping
Post by: dougp on 09 Feb 2018 09:43:16 AM
What version of Cognos?
Title: Re: Crosstab Grouping
Post by: NiceCube on 12 Feb 2018 04:46:08 AM
Hi Doug - I posted in the Cognos Analytics forum, so v11 (11.0.7, specifically).

Cheers
Title: Re: Crosstab Grouping
Post by: Cognos_Jan2017 on 13 Feb 2018 02:58:46 PM
I am not sure this will help your scenario, but
from another thread answered by Kiran P. ...

Will this help ?? ...
There is a property Group Repeating Cells When Exporting To Excel in report properties which when set to No will in-group and show values in every cell. 
Title: Re: Crosstab Grouping
Post by: NiceCube on 14 Feb 2018 02:44:55 AM
Hi - yes, that's perfect.  Thanks so much - I haven't come across that one before, but very useful.

Cheers,

Richard
Title: Re: Crosstab Grouping
Post by: Cognos_Jan2017 on 14 Feb 2018 07:30:18 AM
You are welcome.  Glad to help.

Kiran P taught me that.  The beauty of Cognoise is that we can learn from (and teach) each other.
Text only | Text with Images