Can we filter data using values from two columns?

Summary:

To obtain the data using values from two different columns.

Content (please ensure you mask any confidential information):

I am working with Workforce Management - Worker Assignment Event Real Time. I am using Organization —> Organization Hierarchy folder. We have a level 1 organization and level 2 organization name in the analysis. We have another field from Job —> Job Legislation in the analysis that provides the overtime information that have the values as Exempted or Non-Exempted.

We have a business need to only include exempted employees for D and F level 2 organization, and both, exempted and non exempted employees for A, B, C, E, G level 2 organization.