Help with Hierarchy

[hopkinsc]

Hi all,

I'm trying to get a bill of materials Hierarchy working, Can anyone explain how this function is used please?

[#2]

Hi,

You can try as

Hierarchy(FatherCode,ChildCode,Name)

Load

*

from

....,

so you can get a possible hierarchy and from that you can perform your calculations.

hope it helps

[its_anandrjs]

You can try like this way

Hierarchy:

HIERARCHY([Father Code], [Child Code], Name)

LOAD

     [Father Code],

     [Child Code],

     Name

FROM

Location;

Or you can try this way from this post

Re: Table refering to itself