I have a data set layout that looks something like this: ID Category Score 1 A 100 2 A 95 3 B 80 4 A 75 5 C 70 6 B 65 7 A 60 The data set needs to be sorted by descending score. However, I have a requirement where after the fact the top 4 need to contain at least one "A" and at least one "C" category, so the resulting would end up like so: ID Category Score 1 A 100 2 A 95 3 B 80 5 C 70 6 B 65 7 A 60 Does anyone have advice on how to tackle this? I'm thinking potentially someething with some counters and a retain statement but I'm not sure how to keep it going until the above stated criteria.
... View more