-
1. Re: Custom Filter with Excluded Values
Mark Holtz Nov 13, 2012 7:09 AM (in response to Trish Cox)3 of 3 people found this helpfulHi Trish,
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!
-
2. Re: Custom Filter with Excluded Values
Tracy RodgersNov 13, 2012 10:57 AM (in response to Mark Holtz)
Great idea Mark!
-
3. Re: Custom Filter with Excluded Values
Trish Cox Nov 14, 2012 8:34 AM (in response to Trish Cox)Thanks Mark!
This worked perfectly.
Trish
-
4. Re: Custom Filter with Excluded Values
saikiran Tadiboina Dec 19, 2013 8:16 PM (in response to Trish Cox)Hi Mark,
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.
-
5. Re: Custom Filter with Excluded Values
Rupesh Lad Jun 15, 2016 11:19 AM (in response to Mark Holtz)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.
-
6. Re: Custom Filter with Excluded Values
Praneeth Subudhi Mar 14, 2017 4:40 AM (in response to Mark Holtz)Many Many thanks Mark.
I had exact same problem, and your approach helped me :-)