Hi, I'm working on a very large dataset with lots of dimensions where I need to pre-calculate the distinct number of orders based on different hierarchies. I've built a simple workflow with dummy data based on Tableaus superstore dataset which demonstrates what I'm trying to achieve but I need it to be dynamic so the user can select multiple fields and the alteryx macro will calculate all possible levels. My thought is that an iterative macro would be the solution here but I'm unable to figure out the logic or find similar examples online. Any help would be appreciated.
