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
I tried with groups, but they work only if I know the exact hierarchy level number. List and tables can work with hierarchy, but I dind't find a way for them to calculate the sum up in the hierarchy.
Does anybody know how to do it? Or at least if it's possible.