Totals within headings
under review
M
Mark Hasse
It's great that subtotals reset at the next heading, but befor doing so we need another level of totals:
- Subtotals (as is)
- Totals (new - cummulative of the current heading, including any subheadings underneath the current ending (H2 & H3 within H1, H1 total would include H2 & H3 totals))
- Grand / Smart Total (as is)
Alik
Heading A + B + C + D
## sub 1 A + B
subtotal 1 A
subtotal 2 B
## sub 2 С + D
subtotal 1 C
subtotal 2 D
Zac @ Soulver
Alik: Thanks for the mockup - yeah this would be useful.
Anyone know of any other tools that have feature this behaviour already?
Alik
Zac @ Soulver: Google Sheets subtotal function is the most powerful. It supports not only sums but also average, count and so on. Here is some video about it. https://www.youtube.com/watch?v=pJWkeIHdwBw&t=3s
Zac @ Soulver
under review
C
Chris Abney
Agreed!