Group data in one column but sort by another

[#1]

Hi! 

I have been trying to organize a set of data to group by the device column (ie all the a's are together, b's, etc), but sort them by the percent failed (ie c, F2 would be first followed by the rest of the c rows, then b, F3, and so on) similar to the picture below. When I sort by percent I get the left most table, by device I get the middle table, but I am not sure how to combine the filtering to get the right most table. 

Any insights would be greatly appreciated! Thank you.

[#2 · Accepted solution]

Those tables seem to be from Excel, is a JMP or Excel question?

If JMP first sort by Percentage column in Descending order and then sort again by Device in descending order.

Starting point:

Sort Descending by Column3

Sort Descending by Column1

[#3]

Sorry for the confusion I was using generic information in an excel table as an example. That does work, but only if the 'device' column (column 1) with the highest percentage is also at the end of the list. If a 'b' row had the percent highest value, how could you sort it then? 

In this case the descending sort would bring the 'c' group to the top and not have the highest percentage shown first.

For example: 

[#4]

Then you could "cheat" and pre-define the device order:

or add a column with the additional info:

By the way, you can also sort in a single step by first selecting both columns and then clicking on sort/descending.
The columns are used from left to right, so you have to place the main category column left of the subcategory column: