Hi Koen, This gets very close to what I want, however, using your code, the ret_consyears in following example wasn't calculated correctly. Id Year Revenue flag2 flag3More Ret_consyears WANTED_RET_CONSYEARS 1 2015 999 0 0 0 0 1 2016 1001 0 0 1 1 1 2017 989 0 0 1 0 1 2018 1000 0 0 2 1 1 2019 1230 0 0 3 2 1 2020 1425 0 0 4 3 1 2021 995 0 1 4 3 Do you think it is possible? I only the want # consecutive years that met threshold. So in the above example, that ID retained for 3 consecutive years. 1
... View more