Hi Ian,

So rather than add the Name filter on each sheet, you want to add it to one sheet and then apply it across the others. This means there is only one filter instance, and if it's changed in any sheet (or on the dashboard) it will be reflected in all the sheets.

Hope that does the trick

hi Ian,

Yes that makes sense, and we can do this (with a small limitation) with parameters and sets

First Create a parameter of your Last Name values (this will act as our filter). If you do it like the below the parameter will be populated from the field values.

This is the small limitation. Although we can set a parameter (initially) from a field it won't automatically updated the list of values when/if the data updates (so if new names come in, you'll need to go into the parameter, clear it out and then re-set up from that field). This is THE most requested feature for Tableau to add!

Once we have this we need to create a set on the Job Position Title

We then switch to Conditional Set and enter the formula like this

MAX(IIF([Base Last Name]=[Select Last Name],1,0))=1

Then add this set to the filter in the sheets, expose the parameter on your dashboard and you're good to go.

In your example you may need to create a set in a similar way for each of the levels you want (eg. Job Cupa Desc, Jon Soc Fed Desc...etc.) if you only want one row from each of your sheets.

How/why this works takes a bit of thinking about, but is one of my fave tricks! ...once you get how this works I find it gave me a much deeper understanding of Tableau!

Cool. Yeah sets are pretty powerful things and are going to become even more so when Tableau release the option (currently in Beta) to set the set-members from actions!