Cognos Analytics

 View Only
  • 1.  Pivot columns

    Posted Tue May 31, 2022 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

    IBM Champion
    Posted Tue May 31, 2022 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 Tue May 31, 2022 10:08 AM
    Hi Patrick,
    is it possible to pivot columns in a data module?
    Best regards,

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



  • 4.  RE: Pivot columns

    IBM Champion
    Posted Tue May 31, 2022 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
    ------------------------------



  • 5.  RE: Pivot columns

    Posted Tue May 31, 2022 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
    ------------------------------