I have a spend file that includes a category of spend at 1 of 4 possible levels (L1-L4) for every single record.
I have the taxonomy file that lists all the possible combinations of L1-L4. Column A is L1, Column B is L2, etc...
What I would like to do is specify the L2 from the Taxonomy file and see every record from the spend side that rolls up to that L2.
For example, if my taxonomy looks like this:
and I want everything from the spend that is in any category below (and including) Toys (L2), how can I do that without creating a filter and explicitly including the 8 possibilities? I'd like to make this repeatable where I can just say "show me Toys (L2) and it works.
Appreciate any pointers! Thanks.
Solved! Go to Solution.
Just to try and understand the question are you looking for a hierarchy structure similar to something like this Solved: Displaying Hierarchy of Managers - Alteryx Community ? Could you show an example output table you would want?
Thanks,
Ira
Hey @TeamTJ,
From looking at your output I think this captures your logic (workflow linked below):
If you have any questions on how it works make sure to ask :)
HTH,
Ira
Once I realized I needed to change the filter to my specific L2, it seems to be working perfectly.
And it makes sense, too!
Appreciate the help, this will make the rest of my day much easier!
Great to hear @TeamTJ, glad it helped !