Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
Back to discussions
Expand all | Collapse all

Pivot or Transpose kind of functionality in Cognos

  • 1.  Pivot or Transpose kind of functionality in Cognos

    Posted Mon April 13, 2020 03:24 AM
      |   view attached
    Hi Team,

    Would like to know whether Cognos has the ability to perform Pivot or Transpose kind of operation? Please find the attachment where I would like to transform Source data (i.e; Column A,B,C) in the attachment to transform like target (i.e; E,F,G,H). I have seen the functionality of Crosstab but I just not looking for displaying the data but would like to provide user prompts on the columns once they are transformed.  Basically the data is loaded as rows but would like to transform into Columns as like normal table structure and provide prompts to the user on the columns to see related data.

    ------------------------------
    Sesidhar A
    ------------------------------

    #CognosAnalyticswithWatson

    Attachment(s)

    xlsx
    Specification Attributes.xlsx   10 KB 1 version


Related Content