in the attached file my requirement is to get Top 10 City based on Sales by default when user changes values in 'state' filter.
Alternatively if users changes values in 'city' of his choice then results should be displayed accordingly overwriting the default top 'cities' shown.
Please help me in getting this done.
For your first requirement:
Have you tried creating a Nested Sort as seen here?:
For the second part of your question, could you provide a bit more detail about what you're looking for? I'm not sure I'm understanding.