Top and Bottom 5

Hi Everyone, 

I know its a very simple query but I don;t know why I am not gettting the correct results through filter.

Top5 Conditions

I have student ID along with distance travelled in a race. I want to filter the students who have covered more than 100m in race also want the top5 studeny by distance cover (higher the distance would be first) along with I have given a rating so for Top category rating should also be 5. So two conditions here for Top 5 - Distance is more than 100m, Rating would be 5.

Bottom 5 Condition

Rating would be 1 and distance covered would be more than 100m again. (I dont want to consider 0 in bottom rating)

Below is sample data

I used a matrix where I have student name in first column, distance covered in second column, rating in third column. I filtered Rating as 5, Distance is greater than 100 but when I am filtering Top5 by distance it is showing blank.

Refer below snapshot

Kindly help.

Regards

Uphar