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