Hello, I need your help with a formula.
Im trying to get all the value from another table and next count how many they are for a year.
I added a virtual column [Selection CP] (list) :
=SELECT(Rapport Client[Date entretien :], LEFT([code postal :], 2) = [_THISROW].[Dept], [Date entretien :]>โ01/01/2017โ)
and another [Nbr Rapport CP] (number) to count the previous virtual column :
=COUNT([Selection CP])
But i get all the value, not only the one who was made after 01/01/2017
Could you help me please?
thank you
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |