Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with year, people ID, and a column that says if he/she is retired or not.
People retired is acumulated every year. So at 2020, the table shows people retired during 2018, 2019 and 2020.
I want to show, per year, only the ID of new people retired, excluding people retired during previous years. I attach an excel sheet with the original table, the filter I need an the final answer desired.
Thanks.
Dim1: Year
Dim2: ID_persona
Expression:
if(Year=min({<Retired={"Yes"}>}total <ID_persona> Year),
'Yes'
)
Dim1: Year
Dim2: ID_persona
Expression:
if(Year=min({<Retired={"Yes"}>}total <ID_persona> Year),
'Yes'
)
Thank you very much. It works!
Now I have to understand better how 🙂