Keep Subtotals on Nested Tables

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:

4 Likes

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.

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

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.