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.
Here is my solution
My solution attached
Definitely not the best way of doing this and wouldn't work if there was a level below analyst. Looking at other solutions it's clear I needed an iterative macro! Have gone back and built one now.
Definitely had to peek at pictures of other solutions for this one. Still find iterative macros hard to wrap my head around but great exercise!
learned a lot about iterative macros.
similar to the standard solution attached
Didn't use a macro, too lazy.
Thanks for the challenge! This is my solution.
Not done by iterative macro but I have done this in like 10 minutes? I will deffinetelly look at it once I'm home from Prague Alteryx User Group.