Thank you for prompt answer, highly appreciated.
If I am not mistaken, your idea is to filter using "Rank" -> Range of values =from 1 to 10. Sounds like a plan!
The problem I have now is that, rank is not working as I would like it to work. I simplified the mock-up workbook too much. The database I am working on looks more like below.
I do not want "Rank" to split and duplicate Customers, the way it does. I would like it to look like Rank is not even in Rows sections.
Do you know how to change it or maybe you know some materials I could use? I tried to find such a thing but failed.