I'm trying to execute the below query . And when used Reported by[which is a drop down field and has multiple options such as Customer, IV&V / TE, Factory , ME ...) for SWD and customer it is working but when using it for other drop down options such as ME or IV&V / TE or Factory ... I'm not able to execute the query.
(project = XXXXX) AND ("Reported By" != Customer AND "Reported By" != SWD AND "Reported By" = "IV&V / TE" )