Is there a way to create a derived field to pull based on another field?

Hannah Johnson

Example:

I want to return (RREmployeeRel.ReportingRelation.ManagerEmpID) from WorkAssignment when (RREmployeeRel.Level = max(RREmployeeRel.Level - 2))

Specifically trying to pull the Hierarchy of Management from ReportingRelationship so I can add it to specific derived fields for a File Creation Utility.