How to Subtotal?
Hi all,
Is there a way to get subtotals out of a list?
I have (in the Sankey test) a list of cities with attached numbers of court cases. I want to subtotal those by city. Is there a way to do that?
Cheers,
Rob.
Keyboard shortcuts
Generic
| ? | Show this help |
|---|---|
| ESC | Blurs the current field |
Comment Form
| r | Focus the comment reply box |
|---|---|
| ^ + ↩ | Submit the comment |
You can use Command ⌘ instead of Control ^ on Mac
Support Staff 1 Posted by john on Nov 08, 2017 @ 11:13 PM
Hi Rob,
Yes, it's not too hard.
Make a subnet which filters your table by a city, looks up the cases, and returns a sum. Then all you have to do is lookup a distinct list of cities and feed that into your subnet.
Screenshot and demo network attached. The subtotals subnet can be used with any table.
John
2 Posted by Rob van Wees on Nov 09, 2017 @ 12:55 AM
Thanks John, I'll have a go at that.
In the mean time, have a look at the Sankey diagram thread, I put a version with subtotals there. That shows the view I was going for.
I did all of the counting outside of NodeBox, gonna try to do it with the subotals subnet next :)