Multti level hierarchy aggregation

[XaviDomènech]

Hello,

I need the top nodes to the hierarchy to accumulate the values of the child nodes in a tree structure.

I upload my data:

Hierarchy(NodeID, ParentID, NodeName, ParentName, NodeName, PathName, '\', Depth) LOAD * inline [
NodeID, ParentID, NodeName
1, 4, London
4, 5, UK
5, , Europe
6, 4, Bristol
];

LOAD * inline [
NodeID, import
1, 12
6, 11
];

I have:

If I show de sum() at the tree format, the upper nodes not acumulate the values.

 Can you help me???

Thanks

[rubenmarin · Accepted solution]

Hi, you can try with HierarchyBelongsTo():

HierarchyBelongsTo (NodeID, ParentID, NodeName, ParentID, ParentName, DepthDiff)

And calculate the sum by ParentName

[XaviDomènech · Accepted solution]

I Ruben

Thanks, the data is correct. 

Do you know how I can representen this hierarchyBelongsTo data in a tree type orgChar??

Thanks