pivot report data on some columns

[sukanya]

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

[MFGF]

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.

[sukanya]

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