Pivot Table for Team Scoring

[zhenry]

I've got a spreadsheet that scores ski races and displays the results. Each racer earns points based on their time, age, and ***.

To get a combined team score, rules state that the top five scores in each team are used including at least one female.

To select the top five I want to automatically include the top scoring female, then the top four racers regardless of ***. Is there a way I can accomplish this with a pivot table? I have all the data in place.

Thanks!

[zhenry]

Again, the censored '***' is "gender".