I have the below fields in my data Seg1 to Seg5 and Also i have Key Level field which shows the combination level. So, my idea is to create an Alteryx App based on the Key level the summarize level should automatically change. I have attached the sample workflow for the refence, could someone help me with this task,
For example, if the key level is Seg1+Seg2+Seg3 then the summary tool should automatically change it to that level.
As I could not come up with how to dynamically specify the field for Group By in Summarize tool, I suggest another way.
Instead of using the column "Key Level", I made my WF so user can specify the fields to be grouped by.
My WF seems a bit long and not sophisticated but this is my best at this moment.