Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi, you can try with HierarchyBelongsTo():
HierarchyBelongsTo (NodeID, ParentID, NodeName, ParentID, ParentName, DepthDiff)
And calculate the sum by ParentName
I Ruben
Thanks, the data is correct.
Do you know how I can representen this hierarchyBelongsTo data in a tree type orgChar??
Thanks
Hi, you can try with HierarchyBelongsTo():
HierarchyBelongsTo (NodeID, ParentID, NodeName, ParentID, ParentName, DepthDiff)
And calculate the sum by ParentName
I Ruben
Thanks, the data is correct.
Do you know how I can representen this hierarchyBelongsTo data in a tree type orgChar??
Thanks