1 of 1 people found this helpful
I would lobby for a [Customer Type] field in the data.
You'll want that some day anyway. Having it now will let you filter out employees where you need to filter them out.
And there are two ways to filter something globally.
1) You can make a data source filter. That would filter in/out rows as Tableau retrieves them from the data source. In effect, this sort of filter behaves as if you had previously removed the rows from the data before ever telling Tableau to look at the data source. But the cool thing about a data source filter is that you can still control it from within Tableau at the user-experience level. I have a workbook that uses many data sources. Each data source has a column for a business segment. The user has a parameter that lets him select a single type, or ALL. I have a data source filter on each data source that has this condition on it:
[Managed Segment] = "All" or
UPPER([ManagedSegment]) = [Managed Segment]
User sets the [Managed Segment] parameter to a specific segment, or ALL, and gets the appropriate data.
2) Create a quick filter, and set it as "Apply to..." all worksheets that use this data source.
Thank you!! This is very helpful.