Create View Based On Conditions

I am trying to create a mileage app that our employees can input their monthly mileage. I would like to have a UX view that allows the supervisor to view the list of their employee’s monthly mileage. I have two tables. One with the mileage data and the other with employee data which contains Name, Email, Role, Region. So if the employee table shows an employee with the role of commander, I would like them to see everything within their respective region.