Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI feel certain this could have used fewer tools in the macro, but considering this is the first time I've gotten an iterative macro to work on my own, I'm leaving it!
Attaching my solution here.. This solution will work even if hierarchy is not in sequence..
Nice little iterative macro was the way I figured this one out
Challenge Solution
I count myself to the very beginners with alteryx, this was challenging, and probably my solution is not very efficient, but still I got needed result.
The very con of my approach it that it is not dynamic, but please don't judge me :)