# Reporting Module: Adding total line for each grouping from single data source

**URL:** <https://forum.inductiveautomation.com/t/reporting-module-adding-total-line-for-each-grouping-from-single-data-source/38597>\
**Category:** Ignition\
**Created:** [September 11, 2020, 1:32pm UTC](https://forum.inductiveautomation.com/t/reporting-module-adding-total-line-for-each-grouping-from-single-data-source/38597 "2020-09-11T13:32:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [September 11, 2020, 1:32pm UTC](https://forum.inductiveautomation.com/t/reporting-module-adding-total-line-for-each-grouping-from-single-data-source/38597/1 "2020-09-11T13:32:08Z")

</div>

I have a report table with a single data source. The data is then grouped using the report table grouping options. Is there a way to add a line count summary below each data group? The table summary row adds a line below the entire table not each group. I know that a child table in a table group can add the intermediate summary lines, but this is a single data source and cannot be broken up into separate queries. Any ideas?

---

<div class="post-metadata">

**Author:** ![zacht](https://avatars.discourse-cdn.com/v4/letter/z/ea5d25/32.png) [@zacht](https://forum.inductiveautomation.com/u/zacht)\
**Post date:** [September 11, 2020, 2:34pm UTC](https://forum.inductiveautomation.com/t/reporting-module-adding-total-line-for-each-grouping-from-single-data-source/38597/2 "2020-09-11T14:34:34Z")

</div>

If I understand what you’re doing correctly, you can change the kind of rows that are displayed for each grouping column. Select the group you want to add a summary for and check summary. The checked boxes (Header, Details, and Summary) are specific to the selected grouping level (in this case Working\_shift).

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/c/bc7fcff0d228e86102872c41d99f1e3b590f4809.png)

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [September 11, 2020, 2:51pm UTC](https://forum.inductiveautomation.com/t/reporting-module-adding-total-line-for-each-grouping-from-single-data-source/38597/3 "2020-09-11T14:51:39Z")

</div>

I thought I had already tried what you mentioned, but I couldn’t remember so I tried again. My data source is `optimized` and the grouping is `marker`. I added the summary line to the `marker` grouping and it shows up one time, not per grouping. I added the summary to `optimized` and it showed up like I wanted, which seems backwords logically. But it works 🙂