Nested SUBTOTAL

Lets imagine that instead of using filtering on our data to see the subtotals we want a more dynamic structure
Consider the following table of data

Ignoring all Formulas containing SUBTOTAL