Cognos Analytics

 View Only
  • 1.  Pourcentage of total per line in a table

    Posted Wed February 28, 2024 12:58 PM

    Hello everyone, 

    I just begin to use IBM Cognos this week and I would like to build this kind of table. 

    My problem is that I want the percentage to be calculate per line and so have 100% for all the line in the column "Récapitulatif"="Total". 

    The value that I use to fulfill the table is the number of value for the column. ( C, D, E, G, J)

    Do you have any idea how to do it ? 

    Don't hesitate if it is not clear. 

    Thanks in advance ! 

    Adrien 



    ------------------------------
    Adrien POUDE
    ------------------------------


  • 2.  RE: Pourcentage of total per line in a table

    IBM Champion
    Posted Wed February 28, 2024 04:56 PM

    How is the percentage calculated? Is this coming from the database, or model, or is it being done in the query? If so, can you paste in the calculation? On row 3 you have C, D, and J as 100%. Is that not correct? 



    ------------------------------
    Paul Mendelson
    ------------------------------



  • 3.  RE: Pourcentage of total per line in a table

    Posted Thu February 29, 2024 10:25 AM
    In bottom image, I used "Quantity" (1), but in upper image I used calculated column "% Column" (2). This calculated column is using calculation (3). This formula will give you the result you need. Totals are now 1.000 (4). Just change formatting to percents.


    ------------------------------
    Milan Milovanovic
    ------------------------------