Best way to capture hierarchy tree and sum

[jessy_chow]

Hello, 

Attached is a sample of my data for help. 

Everyone employee reports to manager which then reports to a director and then reports to a VP. The positions are identified via a positionID. 

I am trying to populate this relationship in alteryx as well as getting the total of FTE per Cost Centre. (See spreadhseet for desired outcome)

I have demo-ed out what my desired outputs are in the attached excel sheet. 

I really hope this makes sense. I can try to clarify if needed. 

Thanks soo much! 

[jessy_chow]

a part-time employee