How to show the rank for a dimension member across different level/segments and not display the full list of dimension members.

I'm trying to let the user select a city and then show how that city ranks for various measures at 3 different levels (Nationwide, Region and State). I want to just show the rankings for the selected city without the full ranking list (e.g. Miami ranks 47 out of 531 cities nationally for sales, 15 out of 125 cities in the South region, and 4/36 cities in the state of Florida). I've tried using LODs nested in the RANK function but haven't been able to get it to work. Please see the attached workbook.

The image below is a mock up of the type of view I'm trying to build. In this example I'm trying to show the rank for 3 measures (Sales, Profit, and Quantity) for the city = Miami. I'm including Region and State filter selections to allow the user to narrow down the city list so there isn't a lot of scrolling.

Thoughts?

Todd