Expense audit by employee job

Summary:

We've expense audit selection rules as below.

Threshold amount more than 500USD

Expense item date more than 120days

Policy violated expenses.

Now,Business wants to audit expenses based on employee job code.Not able to achieve it using lookup option.

Need leads how to meet this criteria.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):