Variable index performance

[MPearson88]

Could someone please help with something that I cannot get to work. I am looking to pull out the highest indexing variable per customer type, I do not need the value but I need the related variable . e.g A01 highest indexing measure is 12.32 for age and that is in the 41-45 variable i want to see that. There are 66 customer types and 12 measures so I need to see the top indexing variable by customer type for each of the 12 measures.

Thanks in advance.

[BrandonB · Accepted solution]

Probably something like this. I added the "Who we are" filter at the end so I could check my work but you can remove that if it isn't needed. Basic concept is a transpose to get all of the columns into one, a sort so the values are descending, and then a sample of the first record of each group. Workflow is attached. 

 

[MPearson88]

Brandon, 

Thank you that looks exactly what i want but i cant download your solution as i have an older version of Alteryx Designer, is there any way you could share on an older version or do you have any other way of sharing?

Thanks,

[BrandonB]

What version do you have? I can tweak something for you

[MPearson88]

I have managed to replicate this so it has now worked, thank you