Cognos Analytics

 View Only

  • 1.  Crosstab - summary sort

    Posted Wed June 26, 2019 10:22 AM
    Hi All,

    I have below crosstab in cognos and I am trying to sort summary column (Column F) in but it is not working.
    Can anyone help me?





    ------------------------------
    - K P
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Crosstab - summary sort

    Posted Thu June 27, 2019 09:15 AM
      |   view attached

    @K P - You can create a custom sort calculation like total([Measure] for [SubProduct]) and use that calculation as the advanced sort option for the SubProduct Row.

    I've attached a sample report spec for reference. The Report was built using Cognos Analytics 11.1.1 using the Go Sales(query) package.



    ------------------------------
    DENNY NAREZNY
    ------------------------------

    Attachment(s)

    txt
    IBM_Crosstab_Custom_Sort.txt   5 KB 1 version
    Original Message