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!
