Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: meghanshbajaj on 06 Aug 2020 11:59:57 AM

Title: Data items in Columns
Post by: meghanshbajaj on 06 Aug 2020 11:59:57 AM
Hello people,

I have several data items in a list but not limited to Name, Company, Year, Province & Revenue. The data is currently as:

Name     Company     Year    Province    Revenue
ABC        Tech_1        2017   CA            25000
ABC        Tech_1        2018   CA            29000
ABC        Tech_1        2019   CA            35000
DEF         IT_1           2017   NY            12000
DEF         IT_2           2018   NY            90111

I want the output as:

Name     Company     2017     2018     2019
ABC        Tech_1        25000   29000   35000
DEF         IT_1           12000   90111

Note: Crosstabs are not working because i have around 20 other columns and thousands of rows. Any solution will be appreciated. Thanks.
Title: Re: Data items in Columns
Post by: dougp on 06 Aug 2020 02:33:21 PM
Based on what you posted, a crosstab is the best approach.  Why would the number of columns matter?  How would it not be a problem with any other solution that produces the same result?
Text only | Text with Images