What would be your criteria to show a college at the top, i.e. largest number of employees with 'acceptable' rating, or largest 'acceptable' minus 'unacceptable', etc.?
I would like them sorted in descending order by number of employees hired from each college. The rating of acceptable/unacceptable is simply a colour coding and should not be part of the TopN.
Does this make sense?
Normally you would do something like
INDEX() <= [Top N]
and put it on the Filter shelf, selecting True, which gives you control over N in Top N.
But in your case the complication is that the same employee can appear in both Acceptable and Unacceptable (A/U) categories, thus inflating the distinct count, i.e. if the same employee is both Acceptable and Unacceptable, he/she will be counted twice instead of once.
The screenshot below illustrates the problem - distinct count regardless of A/U is on the left, the same but with A/U dimension added - on the right. The colleges here are sorted in the order you want, but I could not find a way to calculate an INDEX() that would take this into account.
The other minor problem is the fact that same college can belong to several hospitals, which you tried to solve by creating a set. But you can't use a set in table calculations, so I joined two text fields instead to get the same result, and this new combined college/hospital label can be used in table calculations. But, unfortunately, everything gets stuck on the problem above.