Hierarchy

Question

Hello all,I am trying to build a hierarchy of 5 levels of management. Example below:Level 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Level 5Manager 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager 4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager 5Manager 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager 5Manager 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Manager 5&nbsp;In soem cases, each level has a different manager and in some cases the rollup does not include different managers like rows 2 and three. Is there a way I can build such hierarchy without showing the repeating managers in different levels?&nbsp;I hope I have been clear enough but please let me know if more details are required.&nbsp;Thank you,Sassan

v-sihou-msft · Answer

sathari
&nbsp;
It's quite a strange scenario that one person&nbsp;can have different managers.
&nbsp;
I think it's better to have Employee (child) and Manager(parent) columns to display a parent-child hierarchy. In your scenario, you have different level hierarchies, you may create one table for each "level hierarchy" category.&nbsp;
&nbsp;
Regards,

Forum Discussion

Hierarchy

1 Reply

Related content

Date hierarchy

Date Hierarchy

Ragged Hierarchy?

Field Parameter Hierarchy

Dynamic Subtitle with Hierarchy Slicers