# Keep Subtotals on Nested Tables

**URL:** <https://pug.phocassoftware.com/t/keep-subtotals-on-nested-tables/745>\
**Category:** Product Ideas\
**Created:** [October 10, 2018, 3:45pm UTC](https://pug.phocassoftware.com/t/keep-subtotals-on-nested-tables/745 "2018-10-10T15:45:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![tim.janes](https://sea1.discourse-cdn.com/flex015/user_avatar/pug.phocassoftware.com/tim.janes/32/361_2.png) [@tim.janes](https://pug.phocassoftware.com/u/tim.janes)\
**Post date:** [October 10, 2018, 3:45pm UTC](https://pug.phocassoftware.com/t/keep-subtotals-on-nested-tables/745/1 "2018-10-10T15:45:31Z")

</div>

It would be good if subtotals stayed by the top-level entity when drilling down in nested table mode. It is set up that way in Financial Statements, but not in regular databases. The subtotal disappears once you expand an entity. In this example, there would be a subtotal value for entity 31521 of approximately $1,600:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/phocassoftware/original/1X/4dce4a4bba10fc631c03ede59fa7f1b2fa0f4c84.png)

---

<div class="post-metadata">

**Author:** ![anon33838874](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@anon33838874](https://pug.phocassoftware.com/u/anon33838874)\
**Post date:** [October 16, 2018, 5:45pm UTC](https://pug.phocassoftware.com/t/keep-subtotals-on-nested-tables/745/2 "2018-10-16T17:45:01Z")

</div>

Hi @tim.janes. I’ve logged this suggestion in our system. We’ll let this gather interest and see if this can be included in our query improvements roadmap.

---

<div class="post-metadata">

**Author:** ![mauricio.moreno](https://avatars.discourse-cdn.com/v4/letter/m/4491bb/32.png) [@mauricio.moreno](https://pug.phocassoftware.com/u/mauricio.moreno)\
**Post date:** [August 13, 2019, 1:20pm UTC](https://pug.phocassoftware.com/t/keep-subtotals-on-nested-tables/745/3 "2019-08-13T13:20:15Z")

</div>

Hi @tim.janes,  
I’m having a lot of difficulties creating a nested table, mine is not showing the + - signs, any idea why? Thanks a lot

---

<div class="post-metadata">

**Author:** ![Johnathan](https://avatars.discourse-cdn.com/v4/letter/j/67e7ee/32.png) [@Johnathan](https://pug.phocassoftware.com/u/Johnathan)\
**Post date:** [July 14, 2022, 2:10pm UTC](https://pug.phocassoftware.com/t/keep-subtotals-on-nested-tables/745/4 "2022-07-14T14:10:34Z")

</div>

Another vote for the option to keep totals on the nest. I am using this to summarise call quantities for different inbound lines and want to see the total as well as the split.