I normally use sort and index to get the top N records, but I can't in this case due to some design requirements.
I've tried using the pre-set "Top by Field" in the filter, but it does not take the other view filters into account.
My desire is to get the top 2 transportation methods by their countd(ID). Using index it is correct, both CAR and TRAIN have 5 records. When I use the "Top by Field" it incorrectly gives me TRAIN and WALKING (5,4 respectively).