Thank you, Jim. That's close, but what I can't figure out is how to group, filter, create a set, or some other option so that the ID "STU", which is inactive (inactive =1) is included with the other active IDs (inactive =0) and not with ID "ABC", which is inactive. If I apply a inactive/active filter and select active only, then I lose both STU and ABC. I want to keep STU and not ABC, even though they both keep getting removed if I add an Inactive filter, so I'm trying to, I guess, trick Tableau into seeing STU as something different from ABC, even though they are both inactive and that's the filter I'm hoping to use.
1 of 1 people found this helpful
If STU should be always included and ABC always excluded, you could create a calculated field called "Active/Inactive v2" with formula: [active] = 0 OR [ID] = 'STU' and put that in your grid, or use it as a quick filter. The calculation would return TRUE for STU and all that are currently 0, and FALSE for ABC.
For additional inactive IDs to include you can add OR [ID] = 'XXX' to the calculated field.
That did it! Thanks so much, Aaron - really appreciate your help and fast response.