Forum Discussion
Multi level parent child hierarchy summarization
In a hierarchical table "BaseData" , I have to summarise an attribute "timespent" for all LEVELS of child work item. the problem is that the parent (where it need to be summarize) could also be a chi...
A child cannot have two parents in a hierarchy (as opposed to IRL) so ignoring the parent entries for 23156 and 13329. Next we need to fill the gaps for childless parents. Then you can use the PATH functions for your rollups.
I'll leave the next step to you.
Your solution, I believe is eliminating some data, which is something I would like to avoid.