Cognos Analytics

 View Only
  • 1.  Dynamic Label for Total within the Crosstab

    Posted 4 days ago

    Hi All,

    I am new in Cognos and want to add Dynamic Total name as highlighted in below screenshot. Could anyone please suggest how to to do this?

    Thanks in advance.



    ------------------------------
    Jairaj Singh
    ------------------------------


  • 2.  RE: Dynamic Label for Total within the Crosstab

    IBM Champion
    Posted 4 days ago

    Yes. I'll use Go Sales as an example.

    My starting point is this simple crosstab:  

    This produces an output looking like:

    Nest product line within itself, underneath Product Type

    Unlock the report using the padlock icon, Lock Page Objects, found in the top right hand corner of the report editor (next to the page design).

    Drag a text item into the new product line cell, with the text Total in it.

    This gives:

    You can format this total row to make it stand out better.



    ------------------------------
    Marc Reed
    ------------------------------



  • 3.  RE: Dynamic Label for Total within the Crosstab

    Posted 4 days ago

    Thank you :). You make my day.



    ------------------------------
    Jairaj Singh
    ------------------------------



  • 4.  RE: Dynamic Label for Total within the Crosstab

    Posted 3 days ago

    One way to do this is to select the "Total" cell and then in the Properties pane change the Source type to "Report expression". For the expression, use the outer row edge data item concatenated (+) with the string ' Total'



    ------------------------------
    Best regards,
    Syd
    ------------------------------