Group data in one column but sort by another
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 filterin...