Data:
I have this problem where I only want to pick rows from a "group" where the "% of total" for those rows is greater than 75%.
For example: (the data is sorted by group first and then % of Total in Descending order so that I can pick the highest % first)
In group one, Alteryx should only consider Apple and Google since together they are more than 75% and ignore Meta for group 1.
For group 2, it should take apple, google, Meta and Amazon.
Any help is highly appreciated
Solved! Go to Solution.
Thank you @r_manju02 🙂 Very smart trick!