i have a table with columns as "project", "name", "start date" and "end date".
1. i wanted to count the number of employees who has joined the project and also who has left the project per month.
Exmaple: if 10 employees joined the project in jan and 8 in Feb and 12 in march, and 3 left the project in jan, 4 in feb, and 5 in March. i want the result to be shown as, number of employes in jan= 10-3=7, Feb= 7(from jan)+8-4=11, march= 11(from Feb)+12-5=18.
for this i have calculated cumulative count of employees who has joined the project: