Print Page - Converting rows and columns like Transpose option in MS-Excel

Title: Converting rows and columns like Transpose option in MS-Excel
Post by: peewan on 11 Dec 2019 09:29:18 AM

Hi There,

Is there any way we can Transpose rows to columns in Report Studio like we do in MS-Excel?

Normal Output:

Name Salary Band Location
----------------------------------
Marc 10 London
----------------------------------
Henry 20 USA
----------------------------------
Peter 30 Denmark

Desired Output:

Name Marc Henry Peter
--------------------------------------------
Salary Band 10 20 30
-------------------------------------------
Location London USA Denmark

Is there a way to do this in Cognos?

Title: Re: Converting rows and columns like Transpose option in MS-Excel
Post by: Andrei I on 11 Dec 2019 11:45:58 AM

Cognos has an easy Transpose for Crosstab only.

For a List you can use Repeater Table which would require some work.
See an attached example with screenshot and report (ver. 10.1.1 ) against Audit DB

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: peewan on 11 Dec 2019 09:29:18 AM