Print Page - pivot report data on some columns

Title: pivot report data on some columns
Post by: sukanya on 08 Nov 2020 08:26:00 PM

Hi All,
is it possible to pivot report data on some of the columns?

Like in sql
pivot(Max(samplecolumn1) For Samplecolumn2 in (col3,col4, etc).

Above needs to be implemented in cognos report.

Thanks in advance.

Suk

Title: Re: pivot report data on some columns
Post by: MFGF on 09 Nov 2020 06:14:01 AM

Quote from: sukanya on 08 Nov 2020 08:26:00 PM
Hi All,
is it possible to pivot report data on some of the columns?

Like in sql
pivot(Max(samplecolumn1) For Samplecolumn2 in (col3,col4, etc).

Above needs to be implemented in cognos report.

Thanks in advance.

Suk

Hi,

What you are describing sounds like a crosstab report? Have you looked at crosstabs? Is there something more specific you need that crosstabs don't do?

Cheers!

MF.

Title: Re: pivot report data on some columns
Post by: sukanya on 12 Nov 2020 12:16:42 PM

Thank You MFGF!!

I got it using crosstab. SampleColumn2 in column and nested column 1 level below Samplecolumn1 and col3,4,etc as rows.

Regards

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: sukanya on 08 Nov 2020 08:26:00 PM