Hi guys,
For the sample data attached, which labels are:
censo_emp | Fecha | ffin_emp | valor |
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.
Txs you for your help.
Juan Carlos.