loveyoursite
Technical User
CRV 10. I'm drawing a blank this morning and would appreciate anyone's advice on how best to do this. I need to write a report showing the number of new hires and the number of terms sorted by year then month. I can't figure out what the grouping would be to count both of these on the same report. For example: If an employee was hired Jan 1999 and termed Mar 2000, how do I get the employee to show up in the Jan "Hired" count AND again in the Mar "Term" count? The employee needs to be counted once as hired and once as termed.
Expected Result:
Year Hired Termed
1999
Jan 72 11
Feb 0 7
Mar 32 3
etc.
2000
Jan 108 17
Feb 174 29
Mar 93 6
etc.
Expected Result:
Year Hired Termed
1999
Jan 72 11
Feb 0 7
Mar 32 3
etc.
2000
Jan 108 17
Feb 174 29
Mar 93 6
etc.