IBM Business Analytics

 View Only
Expand all | Collapse all

Crosstab with Column Headers for grouped rows using Cognos for Microsoft Office = NOK

  • 1.  Crosstab with Column Headers for grouped rows using Cognos for Microsoft Office = NOK

    IBM Champion
    Posted Thu April 25, 2024 10:46 AM
      |   view attached

    Hello Cognoids,

    the business department requested to have column headers in crosstab.

    Found solution by adding empty cells to crosstab and then hiding the edge of the crosstab and the fact cells with boxtype none. 

    This works well in HTML and Excel. But not when using Cognos for Microsoft Office.

    HTML

    Excel

    This works well when exporting to Excel.

    Cognos for Microsoft Office

    Importing the report into Excel using Cognos for Microsoft office shows the "hidden" cells again.

    Attaching the report sample specs.

    Any ideas on how to achieve column headers in crosstab when using Cognos for Microsoft Office?

    Might this be a bug?

    Regards,

    Ralf

    #Cognos Analytics with Watson



    ------------------------------
    Ralf Roeber
    https://linkedin.com/in/ralf-roeber/
    ------------------------------

    Attachment(s)

    xml
    report_crosstab_with_column_headers.xml   10 KB 1 version