Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Total Sum not showing

    Posted Fri February 04, 2022 08:51 AM
    I want to show this Figure in Cognos, It is a Revenue Column in Excel & its sum is USD 176 Million.













    I'm unable to show the sum instead it's showing in below yellow highlighted format.


    ------------------------------
    Dawood Qureshi
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Total Sum not showing

    Posted Fri February 04, 2022 09:25 AM
    Hi Dawood,

    can it be that the column was recognized as attribute and not as measure? Please check the small icon in from of the column name in the data source pane on the left. Does it look the same as your "Count" column (ruler icon)?

    And then you should be able change the widget type from Table to Summary.

    ------------------------------
    Robert Dostal
    Team Leader BI
    GEMÜ
    Ingelfingen
    ------------------------------

    Original Message


  • 3.  RE: Total Sum not showing

    Posted Fri February 04, 2022 09:55 AM
    Hi Dawood,

    Right click on Revenue, select Properties, then make sure you have the following:

    You shoud now have:

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------

    Original Message


  • 4.  RE: Total Sum not showing

    Posted Fri February 04, 2022 10:12 AM

    I think there's quotes around that value. This suggests that the source CSV has at least one (possibly two as the next value down seems to have that problem too) value for revenue column which has non-numeric characters. This will result in the column being understood to be a string data type rather than a numeric data type.  You want the latter if you intend to use the column as a measure (aka fact).  

    On the top right hand corner of the widget there is an round, yellow icon.  Click on it and it could provide some information that can be helpful as well. 

    Examine the CSV and correct it so that, when you reupload it, the column will be stored as a numeric data type.  

    I would advise that you put your CSV into a data module before using it in a dashboard. This will enable you to perform more modelling activities, including adding additional data sources to the module, which will allow you to use them easily in your dashboard.



    ------------------------------
    IAN HENDERSON
    ------------------------------

    Original Message


Related Content