Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Custom Sorting

    Posted Mon February 03, 2020 04:53 PM
    ​Can anyone help on how to do "custom sorting" based on other data item on 11.1 Visualization (as shown below)(Pls ensure after sorting, it should be rendered into PDF as well) whereas this option existing on older visualization (11.0, Legacy, Charts...etc). Your help is much appreciated!





    ------------------------------
    Hakkim A
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Custom Sorting

    Posted Tue February 04, 2020 09:09 AM
    The following technique works with 11.1 charts:
    1. Add the sort column data item to the query.
    2. Set the Pre-Sort property of the Query Item to Ascending or Descending as required.
    3. Add the Data Item to the "Extra Data" area of the chart data.
    Hope this helps.

    ------------------------------
    David Hill
    ------------------------------