Show data for a dimension associated with the selected dimension
I am simply trying to create an expression in a text object that will show a count of items for a Region if a State in that Region is selected. For example, if someone selects Boston, I want to show the count of items for the Northeast Region.
This is the expression I'm using, but it is not working the way I want it to. It is only showing the Count for the state I select, not the Region:
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.