This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Getting stuck trying to build hierarchy levels for account data. Here is an example of what I want the outcome to me. The level is what I am after. The root (level 1) always has a null for parentid in the dataset. Was attempting an iterative macro but I am struggling.
@danilang Sorry about that! The input data are the 2 left columns. Id and Parent Id. Below is the example. I am attaching an example of how I do this manually. The problem with this is I would need to build out for every new level. I want it to be dynamic.
After I ran the first tile statement all of the people in my list have been grouped by their supervisors. Which is great! Do the supervisors need to be grouped again by their supervisors, or is that already complete. Sorry for the silly question; I am just trying to get my head around a recursive process for my data.
Data looks like this:
Supervisor Unique ID
The only time the Unique ID would match the Supervisor ID would be in the case of the CEO.