How to put hierarchical data in one column ?

[Rubio]

Hi Guys;

In my organisation I need to make a table with two Columns : Heads (some leads); Subs (employees working under their multilevel hierarchy).

I have 1 table with Heads identifiers, and one table with an identifiers mapping N:N+1 that allows to know for each employee his N+1.

Which formula can I put in the second column (Subs) to have all the employees under a lead what ever level they have ?

Thank you.

[jwjackso · Accepted solution]

With parent/child data, you can use the HierarchyBelongsTo.

The AncestorID will be linked to all the children that belong to them and their descendants.

[Saravanan_Desingh]

Can you show some sample and expected output?

[Rubio]

Thank you Jwjackso !

This is the right function.