Add possibility to create dynamical multilevel groups

My team had the following task and we'd be really glad if we could achieve this using Jaspersoft.

Please, refer to the attached image for more clarity.

In the Name column I have a dynamic hierarchy, where I don't know how many levels may be. In my database, I have values only for leaf elements (in this case the Subchild elements). I need to calculate the sum for parent elements (go upper in the hierarchy). For example, if we look at Type1 column, Subchild1 + Subchild2 = Child1