3 of 3 people found this helpful
You can create a duplicate of the field you are filtering on. (Right click, duplicate in the Data Window)
(You may also want to name it something innocuous so that curious folks won't try to go messing with it.)
You can then drag it onto your filter shelf and exclude the values you want to exclude. Then, with your "real" filter, set it to relevant values only.
Hope this helps!
Great idea Mark!
This worked perfectly.
This is working fine. I have one doubt same like this. I have Region wise data East, West, North, South. i had send the dashboard to the client. But East region person shouldn't see remaining region data at the same time West region client shouldn't see Remaining regions data vice versa. we can do like this in Tableau.
Thanks Mark. Good Idea.
I would like to add more, if you wanted this this filter to be in all other worksheets then just right click --> Apply to worksheets and choose your option.
Many Many thanks Mark.
I had exact same problem, and your approach helped me :-)