title: Count number of years since last deduction
body: <p>I have a table similar to below where the same account has its fiscal years (FY) and deductions for each year broken out in multiple rows. Accounts can range from 1 - 20+ years. How do I group to one unique row that shows the current year and how many years its been since the account had a deduction?</p>
  <p>from this:</p>
  <p><a href="https://i.stack.imgur.com/9NLff.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9NLff.png" alt="enter image description here" /></a></p>
  <p>to this:</p>
  <p><a href="https://i.stack.imgur.com/sWAdU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sWAdU.png" alt="enter image description here" /></a></p>
  <p>Started to utilize the CTE approach as I have in the past, but as before it started to get ugly and I know there has to be a simpler approach...</p>