How to use one variable to restrict another variable in sap hana calculation view

Hi Experts,

I created one calculation view with two variables. for example: v_department and v_employee(both are from one table). I want to select v_department first; and then the v_employee should only show the employee belongs to the selected department. Is it possible?

Thanks,

Yufei