where 'censo_emp' is the employee number, 'Fecha' is the employee starting date and 'ffin_emp' the employee finishing date, I need to get the acummulated count of FTE in every month,
" FTE at the Date" must be the accummulated count of the field 'censo_emp' between the minimum 'Fecha' available and every month until the maximum month selected.
Month
feb
jun
jul
ago
nov
FTE at the Date
4
1
1
1
1
I've been trying with quite a few dataset formulaes for filtering between dates, but I just get the started in every month or the accummulated value repeated in every month.
