please see the attached
Is this what you wanted?
added actions - the first goes from the Map and transfers only the State value
the second goes from the top 10 states and goes to the city and passes only the State
I used a bar chart - could be txt
this calculates the sales by city by state
and this ranks them
set to city
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.