The part of the demo where he creates a computed field inside the sub-result (in a hierarchy), and then uses that in an aggregate at the next level above is excellent. And then he can still see the constituent rows contributing to the aggregate and continue adding filters on them.
I am sold, even as someone comfortable with writing complex queries.