Hi there,
I am having a pivot table with many shops in 7 countries (countries are first row item, shops the second). for each shop I have column B, C, D, and E which gives me profitability figures. Now I would like to determine my top 10 bottom 10 performing shops of the different countries according to the criteria of B, C , D and E separately. That is, I have a separate worksheet which is intended to show me four tables listing the names & respective numbers of the top 10 and bottom 10 performing shops (in terms of B, C, D, and E criteria) for each country.

I thought about using the RANK() function but this does not allow me to filter for the countries. Can anyone help me with this?

thanks a lot for your time and effort!