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.  Crosstab - summary sort

    Posted 06/26/19 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 06/27/19 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


Related Content