Hi Ben,

Below one is similar topic. I think it will be help you.

Dynamic display of filter on selection of sheets.

You can create two workbooks on Sales Person & Sales Manager and create two vizs in dashboard where you can filter as per sheet names like mentioned in above scenario.

I can't wrap my head around what you are really looking to do.  But let me toss out a few concepts that you might want to leverage.

There is a function you can use in a calc.  Look at ISMEMBEROF().  I use this in multiple places and multiple ways.  We assign users to groups, and ISMEMBEROF tells me if they are a member of the group specified in the parentheses.  If the user is a member of a particular group, I can display more things or hide things or filter things...

If you want some people to see a sheet categorized by one dimension, and other people see the sheet categorized by another dimension (for example, swap in [Cities] for one group and [Neighborhoods] for another) you can have a calc that detects what group is in play and use that dimension:

IF ISMEMBEROF('Cities Group') then [Cities] else [Neighborhoods] END

Now use that calc on the ROWS (or COLUMNS) shelf and depending on what group the user is in, he will see the sheet by Cites or by Neighborhoods.

Further, if you employ the second idea I described, you could also show the [Cities] filter to the Cities users, and the [Neighborhoods] filter to the Neighborhood users.  (And the Cities users won't see the Neighborhood filter.)  And it'll all still be on one sheet.