Monthly Employee Turnover (Joiners v Leavers)

[Cozdis93]

Hello everyone!

I am trying to determine what are the joiners and leavers monthly based on the client data provided.

So far the only way I have been able to do this, is by filtering on the date i.e. January to February and then using the join tool to find what are the IDs that get "filtered" out.

I need to do this for 24 months and this feels liek a very manual process.

See attached below my zip file.

[Maskell_Rascal]

Hi @Cozdis93 

Can you share the input file with me, or at least a sample of what it looks like? The zip didn't include it. 

Thanks!

Phil

[Cozdis93]

Hi @Maskell_Rascal 

Thanks  for letting me know, this one should work let me know if it doesn't!