So, I tricked tableau to show both fields and both work too. I just duplicated the ID field and applied it to all the sheets. So, I have one field to "search for ID" and another to "remove the ID". But one problem - when from "remove the ID" I click 'x' to make it blank or if I put in another id, the previously removed id comes back. I don't know how to counter that, will see or I will be back to square one which is only one filter can work. Anyway just wanted to share this with you.