Good morning Stella
see the attached
I added this formula
and converted it to Geo and placed under city in the hierarchy
then create a state based map using the lod city-state to create the map
I then created a d/b and added a filter
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.
city state.twbx 2.5 MB
Thanks for reply. Is it possible to get it in a single sheet.?