Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to fixate a user count to a specific date and displaying the count on other months in the table,
please find attached qvf and the excel (Data file),
the current table looks like this:
and this is the expression:
Count(distinct {$<Date={"*01/03*"}>}UserID)
the required table should look like that:
i need to apply the count value from each *01/03* to 11 month ahead,
for example, the count of Mar-2020 should appear until Feb-2021
and the count of Mar-2021 should appear until Feb-2022.
after that i need to divide the terminations by those numbers for each month (there is a Termination_Flag in the qvf),
in the qvf you will find two tables,
1. headcount (this is the main issue i described above)
2. % Terminations (the final table)
i am looking for a dynamic solution.
please ask any question if needed,
i appreciate the help.
thanks.
Ido.