Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Pivot columns

    Posted 05/31/22 09:37 AM
    Hi Cognos Colleagues,

    Can the columns be pivoted? How can I do it?

    Best regards

    ------------------------------
    David GOMEZ PRIETO
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Pivot columns

    Posted 05/31/22 09:51 AM
    Hi David,

    Do you want to swap rows and columns?
    From
    to

    Just click on the swap rows and columns icon. You need to select the crosstab before on you won't be this icon.

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------



  • 3.  RE: Pivot columns

    Posted 05/31/22 10:08 AM
    Hi Patrick,
    is it possible to pivot columns in a data module?
    Best regards,

    ------------------------------
    David GOMEZ PRIETO
    ------------------------------

    Original Message


  • 4.  RE: Pivot columns

    Posted 05/31/22 10:13 AM
    Hi David,

    You can swap data in a presentation format (such as a crosstab) in a report, for instance.

    The data module is a datasource, what would be the point to pivot something in the datasource. I don't understand what you are trying to do.

    Best regards,



    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------

    Original Message


  • 5.  RE: Pivot columns

    Posted 05/31/22 10:22 AM
    I always compare myself with power bi, in PBI you can do this "unpivot column".


    it is as if we change the position of the column, we reverse it.
    Best regards,

    ------------------------------
    David GOMEZ PRIETO
    ------------------------------

    Original Message


Related Content