Average age of top 10 in the list using pivot table

[INN]

Hi
I have a table of top 50 tennis players and their rank, ages and countries. How can I find the average age of the 10 top players using pivot table. Right now, I can find the average age of all players. What is the idea to find the top 10 players? Thank you.

 

[awoohaw]

=AVERAGEIFS(agerange,rankrange,"<=10")

Put a filter on your pivot table for rank and click the top ten.

 

[INN]

Thank you.

 

[INN]

=AVERAGEIFS(agerange,rankrange,"<=10")

Put a filter on your pivot table for rank and click the top ten.


View attachment 107034

Thank you for your reply. But when I put Rank as a filter of the pivot table, I wont see an option of "Top 10". I know that option in regular filter but not pivot table filter. Thank you again

 

[awoohaw]

You don't. Just click the arrow in the filter (which is RANK), and select items 1 thru 10.