topic Re: Multti level hierarchy aggregation in App Development

Multti level hierarchy aggregation

XaviDomènech — Sat, 09 Oct 2021 08:02:39 GMT

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

Re: Multti level hierarchy aggregation

rubenmarin — Sat, 09 Oct 2021 09:08:07 GMT

Hi, you can try with HierarchyBelongsTo():

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

And calculate the sum by ParentName

Re: Multti level hierarchy aggregation

XaviDomènech — Mon, 11 Oct 2021 11:36:43 GMT

I Ruben

Thanks, the data is correct.

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

Thanks