Top 10 in Group for Multi-Grouped data set

[kgroppi]

I have a large excel file that contains nine columns of data.  Seven of the nine columns have selections or dimensions.  One of the nine columns has customer’s name.  The last column has the metric or ratio.  For simplicity, assume the seven dimension columns each have two selections.  This makes 128 different combinations of selections among the seven columns. 

I am looking for Alteryx to return only the top 10 ratios with associated customer names for each of the 128 combinations.

What tools in Alteryx would allow me to do this?

[Rlavelle]

Can you share masked or sample data?

Is the data already grouped and/or is the ratio a column in the data or are you looking for the workflow to create the ratio?

[kgroppi]

Here is a sample file

[kgroppi · Accepted solution]

The data in my sample is grouped but in my actual file it is not grouped.

[kgroppi · Accepted solution]

I was able to accomplish what I needed by adding a column and ranking my data.  I then filtered to only return the ranks that I wanted.