Multiple User Filters on Rows

Hi All,

Could you please help me solution for this use case:

Use case: I have a list of Communities with Multiple List formatted properties having User List as dimension. These are to map Community managers, Regional Managers and so on. Now on a board I have this grid with Communities on rows. I want to add a regional director and community manager filter on pages in such a manner that when I select a Regional Manager, I can only see the community managers that roll up to it and when I select a community manager then I only see the communities for that community manager.

Issue: Once I add a property from Community list which is User List formatted, I can’t add another property with the same dimension

Solutions I have already tried: I created a separate Regional Director List with all users with that role within the application. Then I created a metric to Identify all community managers that roll up to that regional manager against the respective communities they have access to. End result of all my calculations: I now have a metric identifying which community managers roll up to which regional manager and consequently which community rolls up to this community manager. I tried using this in my grid using “Map a dimension to the view” feature but nothing seems to be working as expected.