Field selection using two criteria: one simple and one complex
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.