YR over YR Summary Report

I am stumped!  I am trying to make my current (basic) YOY report better.  I have several "clubs" and each of them have new enrollments, membership renewals, and cancellations.  I have not had a problem showing the basics, but this is where I am stumped...I would like for the cancellations to somehow reflect when received and also the original enrollment of that member.  Here is a brief example:

So, I am showing all of the activity happening to the members originally enrolled in 2020.  I am able to get the individual components but not reflect back on the original year if that makes sense?  Or maybe I would need to do a summary report for each year and then pull from each of those to create a true year over year look?  If this has made sense to anyone, please let me know what you think.

Thanks,

Kim

------------------------------
Kim Cameron
------------------------------