------------------------------
Milan Milovanovic
------------------------------
Original Message:
Sent: Sun May 14, 2023 11:22 PM
From: Mohamad Aiman Arif Mohamat Saat
Subject: Move Group By Subtotal Above Details Rows in Report - List Table
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:
![](https://dw1.s81c.com//IMWUC/MessageImages/15c7e5379f984fc7aeac775b9842605e.png)
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:
![](https://dw1.s81c.com//IMWUC/MessageImages/206d5a83ee8648e680729d7e1c060a7f.png)
Set it to look like this:
![](https://dw1.s81c.com//IMWUC/MessageImages/65612aa74db94b6c8063bf8c18b3192e.png)
It will look like this:
![](https://dw1.s81c.com//IMWUC/MessageImages/6891588428d64034a00cc55e4f29bda6.png)
Click on the subtotal row and then the Split Cells button
![](https://dw1.s81c.com//IMWUC/MessageImages/b7254defc50d4fd78e05af5f271ab91f.png)
You'll get this:
![](https://dw1.s81c.com//IMWUC/MessageImages/d450bd5936184cdebe576e4b509a2899.png)
ctrl click on internal_facility_name and sub_product_name and then Merge Cells
![](https://dw1.s81c.com//IMWUC/MessageImages/fdd350da640f4eeb8995551bee048350.png)
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:
![](https://dw1.s81c.com//IMWUC/MessageImages/27301c93dde34c0d8cc72ecb1fdf07e7.png)
Now you can ctrl-drag the Total(previous_balance) from the overall total row or drag them in from the query.
![](https://dw1.s81c.com//IMWUC/MessageImages/70141b7aae4c4d2684c8d9aa5bba6d09.gif)
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?
![](https://dw1.s81c.com//IMWUC/MessageImages/9dfd641ee8854f019abd9ce3d154d130.png)
Any help is deeply appreciated.
------------------------------
Mohamad Aiman Arif Mohamat Saat
------------------------------