Hi since this info is staticI would create a flag at Back End after would use set analysis.
I Did not teste it but you can understand the logic and adjust it.
if(WildMatch(everySatus,'*Not Fixed*') ,0,1) as finalStatus;
concat(Status,'/') as everyStatus
Group By EmployeeID,Status
order by Status asc;
applymap('map_FinalStatus',EmployeeID) as flag_finalStatus
drop Table myBigTable;
RENAME Table temp_myBigTable to myBigTable;