Cognos Analytics

Hi All,


We are using IBM Cognos Analytics with Watson (11.2.0).


I have design this one list table where we group the list table by internal_facility_name and get the total balance for each facility. Is there a way to move the group by subtotal above the data rows?

Any help is deeply appreciated.

Hi All,


We are using IBM Cognos Analytics with Watson (11.2.0).


I have design this one list table where we group the list table by internal_facility_name and get the total balance for each facility. Is there a way to move the group by subtotal above the data rows?

Any help is deeply appreciated.

The first thing I like to do is change the visual aids to uncheck Show Repeating:


It only affects the development environment, but I find it makes it significantly easier to see.

With the list selected click on the three dot menu->Headers & footers->List headers & footers:



Set it to look like this:


It will look like this:

Click on the subtotal row and then the Split Cells button


You'll get this:

ctrl click on internal_facility_name and sub_product_name and then Merge Cells


Next you'll want to drag the measures into the sub-total cells, but in order to do that you'll need to unlock the report:

Now you can ctrl-drag the Total(previous_balance) from the overall total row or drag them in from the query.



This should give you exactly the result you're looking for.

Hi All,


We are using IBM Cognos Analytics with Watson (11.2.0).


I have design this one list table where we group the list table by internal_facility_name and get the total balance for each facility. Is there a way to move the group by subtotal above the data rows?

Any help is deeply appreciated.

The first thing I like to do is change the visual aids to uncheck Show Repeating:


It only affects the development environment, but I find it makes it significantly easier to see.

With the list selected click on the three dot menu->Headers & footers->List headers & footers:



Set it to look like this:


It will look like this:

Click on the subtotal row and then the Split Cells button


You'll get this:

ctrl click on internal_facility_name and sub_product_name and then Merge Cells


Next you'll want to drag the measures into the sub-total cells, but in order to do that you'll need to unlock the report:

Now you can ctrl-drag the Total(previous_balance) from the overall total row or drag them in from the query.



This should give you exactly the result you're looking for.

Hi All,


We are using IBM Cognos Analytics with Watson (11.2.0).


I have design this one list table where we group the list table by internal_facility_name and get the total balance for each facility. Is there a way to move the group by subtotal above the data rows?

Any help is deeply appreciated.

Hi Paul,

Thank you for the detail instructions. Your instructions make it look so easy :)

------------------------------
Mohamad Aiman Arif Mohamat Saat

Original Message:
Sent: Thu May 11, 2023 01:39 AM
From: Paul Mendelson
Subject: Move Group By Subtotal Above Details Rows in Report - List Table

The first thing I like to do is change the visual aids to uncheck Show Repeating:


It only affects the development environment, but I find it makes it significantly easier to see.

With the list selected click on the three dot menu->Headers & footers->List headers & footers:



Set it to look like this:


It will look like this:

Click on the subtotal row and then the Split Cells button


You'll get this:

ctrl click on internal_facility_name and sub_product_name and then Merge Cells


Next you'll want to drag the measures into the sub-total cells, but in order to do that you'll need to unlock the report:

Now you can ctrl-drag the Total(previous_balance) from the overall total row or drag them in from the query.



This should give you exactly the result you're looking for.

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

Original Message:
Sent: Wed May 10, 2023 11:03 PM
From: Mohamad Aiman Arif Mohamat Saat
Subject: Move Group By Subtotal Above Details Rows in Report - List Table

Hi All,


We are using IBM Cognos Analytics with Watson (11.2.0).


I have design this one list table where we group the list table by internal_facility_name and get the total balance for each facility. Is there a way to move the group by subtotal above the data rows?

Any help is deeply appreciated.

------------------------------
Mohamad Aiman Arif Mohamat Saat
------------------------------

Hi Paul,

Thank you for the detail instructions. Your instructions make it look so easy :)

The first thing I like to do is change the visual aids to uncheck Show Repeating:


It only affects the development environment, but I find it makes it significantly easier to see.

With the list selected click on the three dot menu->Headers & footers->List headers & footers:



Set it to look like this:


It will look like this:

Click on the subtotal row and then the Split Cells button


You'll get this:

ctrl click on internal_facility_name and sub_product_name and then Merge Cells


Next you'll want to drag the measures into the sub-total cells, but in order to do that you'll need to unlock the report:

Now you can ctrl-drag the Total(previous_balance) from the overall total row or drag them in from the query.



This should give you exactly the result you're looking for.

Hi All,


We are using IBM Cognos Analytics with Watson (11.2.0).


I have design this one list table where we group the list table by internal_facility_name and get the total balance for each facility. Is there a way to move the group by subtotal above the data rows?

Any help is deeply appreciated.

The first thing I like to do is change the visual aids to uncheck Show Repeating:


It only affects the development environment, but I find it makes it significantly easier to see.

With the list selected click on the three dot menu->Headers & footers->List headers & footers:



Set it to look like this:


It will look like this:

Click on the subtotal row and then the Split Cells button


You'll get this:

ctrl click on internal_facility_name and sub_product_name and then Merge Cells


Next you'll want to drag the measures into the sub-total cells, but in order to do that you'll need to unlock the report:

Now you can ctrl-drag the Total(previous_balance) from the overall total row or drag them in from the query.



This should give you exactly the result you're looking for.

Hi All,


We are using IBM Cognos Analytics with Watson (11.2.0).


I have design this one list table where we group the list table by internal_facility_name and get the total balance for each facility. Is there a way to move the group by subtotal above the data rows?

Any help is deeply appreciated.

Thank you so much for the instructions.  Is it possible to hide this empty area (the data detail)?  When I run the report (2nd screenshot), I got those blank lines.  All I wanted to remain on the report (and when exporting) is the green highlight one.  Thanks.  I'm a newbie to Cognos.

------------------------------
Martie Lysas

Original Message:
Sent: Thu May 11, 2023 01:39 AM
From: Paul Mendelson
Subject: Move Group By Subtotal Above Details Rows in Report - List Table

The first thing I like to do is change the visual aids to uncheck Show Repeating:


It only affects the development environment, but I find it makes it significantly easier to see.

With the list selected click on the three dot menu->Headers & footers->List headers & footers:



Set it to look like this:


It will look like this:

Click on the subtotal row and then the Split Cells button


You'll get this:

ctrl click on internal_facility_name and sub_product_name and then Merge Cells


Next you'll want to drag the measures into the sub-total cells, but in order to do that you'll need to unlock the report:

Now you can ctrl-drag the Total(previous_balance) from the overall total row or drag them in from the query.



This should give you exactly the result you're looking for.

Hi All,


We are using IBM Cognos Analytics with Watson (11.2.0).


I have design this one list table where we group the list table by internal_facility_name and get the total balance for each facility. Is there a way to move the group by subtotal above the data rows?

Any help is deeply appreciated.