Donor vs potential donor

Hello dear community,

I'm classing my donations in 3 category: New (the 1st one), Renew (if last transaction was within 2 years), Ancient (if last transactions was older than 2 years.

I'm able to generate the 1st table with the category for each transactions. But I'm wondering how to build my second one. I have to know, by year, how many poeple are in a category (lets say renew) base on how many could have been (potential).

In my head the calculation for Renew should look something like Count Client Where aRow.Date = Table.Date -1 or -2
and for ancient would look like Count Client Where Date aRow. < Table.Date AND Renew Potentiel IS null.
(in my exemple aRow.Date refer to a single donation row, Table.Date refer to the final table)

The purple notes are just there to explain my data, i don't need them at the end.

Thanks for helping