I might be oversimplifying the complexity of the requirements.
How about creating an aggregated column for total revenue for state and city and give access to user only to specific city?
City, City Revenue, Total Revenue
Chicago, $20, $100
Let me know if this doesn't work and explain the structure of your data. I hope this is definitely doable in Qlik.