Calculating emp left the job?

    Hello everyone,

         I used Count(distinct EMP_CODE2)-Above(Count(distinct EMP_CODE2)) w.r.t Month and got the Difference of Employees those were present in Previous Month and Not present in Current month.Now i want to which particular EmpCode has Left in Tabular Form.

    How can i do that??


    Expected output according to the data : Employee who left-a3

                                                                           Employee who joined:a5


    Thanks & Regards

    Kshitija Shinde