Hello Ryan:
Let me suggest a different approach. Base the report on the transaction table with a link to the Customer table. Sort and group by Customer code. Filter the report to transactions in the past 2 years . Create a separate formula calculation for each period you want to see on the report (using IF). This approach solves both of your dilemmas and will likely run faster too.