Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: crn.professional on 05 Jan 2006 05:33:03 PM

Poll
Question: HOW TO ARRANGE ROWS INTO COLUMNS IN A LIST REPORT
Option 1: post votes: 0
Option 2: e-mail votes: 0
Title: HOW TO ARRANGE ROWS INTO COLUMNS IN A LIST REPORT
Post by: crn.professional on 05 Jan 2006 05:33:03 PM
Hi,

I would like to know how to arrange the row values as columns in a list report. Here is my example

Category                 Period               Value
ELECTRONICS          10                     100
MECHANICAL            11                       50

i WOULD LIKE TO SEE LIKE THIS

CATEGORY                 period   VALUE    period      values
ELECTRONICS            10         100         
mechanical                                            11             50

Could you please let me know how to do that.

Thanks in advance.
Title: Re: HOW TO ARRANGE ROWS INTO COLUMNS IN A LIST REPORT
Post by: mikegreen on 05 Jan 2006 05:38:17 PM
Make period1, value1, period2, value2 calculations..
Make period1 CASE category so when it is electronics then period, else null
then case period2 when category = mechanical then period, else null.

I'm not sure why you would want to do this, though.

regards,

Mike
Title: Re: HOW TO ARRANGE ROWS INTO COLUMNS IN A LIST REPORT
Post by: bdybldr on 06 Jan 2006 07:48:11 AM
I agree with Mike.  This doesn't make sense to me either.  You don't want to display period 11 for electronics...just mechanical?

Will you provide some insight as to the impetus for this type of requirement so we can provide more assistance?  Just curious.  Thanks.
Text only | Text with Images