Is sorting by top 10 items in a group in Pivot Table possible?

[HienFerber]

In my sample file in the Dropbox link below, I have a table of plants with unique ID number, the families they belong to & their age. I created a Pivot Table and Excel groups plants from the same families together for me. However, I cannot seem to filter the oldest plants by families. When I use the "sorting by top xx items" feature in Pivot Table, Excel always shows the 2 oldest plants in whole table regardless of family grouping. What if I want to see the 2 oldest plants by family "Caltha"?

https://www.dropbox.com/s/tpxt2yofy9hz982/samplefileMrExcel.xlsx?dl=0

Thank you!

 

[mole999]

Maybe > https://www.techonthenet.com/excel/pivottbls/top10_2010.php

 

[HienFerber]

Thank you for the link but it does not show how to sort top 10 in a group. I found this thread back in 2013 and it seems the problem was solved by SQL, which I don't know

https://www.mrexcel.com/forum/excel...y-only-top-10-per-group-excel-pivottable.html