excel filter not working with formulas

Now suppose wed like to filter for rows where the Region does not contain East or West. 3 Company scope which is what work types …