Would this help?
If yes, then I have basically joined the data with itself as shown below, and created the above calculated field to identify the excluded value and display in the title.
tableau - list_v10.2.twbx 28.4 KB
I guess you want the excluded list to update each time you update the filter. If yes, you might have to change the structure of your data. This will duplicate the size of your dataset. One approach to minimize the extent of such duplication is to union the data. For optimization purposes, you can use this 'unioned' datasource for this analysis only and then do the rest of your reporting on a separate single datasource.
Step 1: Union the data
Step 2: Create calculated field [Name Filter]
IF [Table Name] = 'names' THEN [Names] END
Step 3: Duplicate Name filter and set up 'Included Names' worksheet as shown below.
Step 4: Create calculated field [Show Excluded]
WINDOW_COUNT(ATTR([Table Name])) < 2
Step 5: Set up 'Excluded Names' Worksheet as shown below. Make the [Names Filter] in 'Included Names] worksheet to apply to 'Excluded Names' worksheet.
Then add both worksheets to a dashboard. Any changes made in the included Names worksheet will update the Excluded Names list.
Hope this helps.
Ossai & Hari both solutions work well for the stated problem, however I failed to state that my dataset is about 6 MM records so duplicating the datasource for a join/union isn't a viable option unfortunately. Going to keep digging on my end, thanks much for the new approaches though.