Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Is there a way to display only the summary rows in a list?

    Posted Fri February 05, 2021 06:25 PM
    Hi all,
            Is there a way to display only the summary rows in a list?  Or perhaps I need to build the report in a different way, with somehow pulling the summary information from an intermediate list.

    Jim

    ------------------------------
    Jim Denton
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Is there a way to display only the summary rows in a list?

    Posted Tue February 09, 2021 07:48 AM
    Hi Jim

    One way to do this is to mark the list column body and set the Box type to none. This will only show you the headers and the summary row

    ------------------------------
    Jesper Bjerre
    ------------------------------



  • 3.  RE: Is there a way to display only the summary rows in a list?

    Posted Tue February 09, 2021 01:39 PM

    Jim Denton – this appears to be a duplicate post, but nonetheless I will try to answer.  Generally speaking, summary rows to me is just a relative term.  Correct me if I am wrong, but what you are trying to do is just develop a list report that shows an aggregate based on a specified list of attributes.

     

    How I usually approach this type of request is to:

    -       Develop a query first, aggregated to a specified level

    -       Then create a list report, that references the query developed in the above step

     

    Hope this helps.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Peter Chan

    613-295--0428

     






  • 4.  RE: Is there a way to display only the summary rows in a list?

    Posted Wed February 10, 2021 02:17 AM
    Hi Jim,

    Have you tried the data table, depending on what and how you want to display the measures, repeaters can also be a good solution,


    ------------------------------
    René Kent Nielsen
    Brand manager
    CogniTech A/S
    Herning
    ------------------------------