For the sample data attached, which labels are:
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.
|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.
Txs you for your help.