Back to PIVOT but from a different angle
I read up on SSRS matrixes and experimented with my query only to find that I needed to created calculated fields off of dynamic fields that don't exist at runtime. So disappointed, but undeterred. I looked at what I could do for advanced uses of sp_executesql and after quite some time researching, I finally settled on creating a table valued function that houses my PIVOT operator query. Hopefully that will get me where I need to be with dynamic columns that change year to year.
Between my meetings and deployments and research, I snuck in a quick bike ride, then a slow walk, as an old injury with my toe left me with a slowly growing damaged toenail that, while it's mostly grown out and new nailbed has appeared, the damaged bit finally fell off, so I wanted to see what kind of pain I would get from going for a walk. The answer seems to be "slight" and "I should probably be careful for a few days and not run until Friday." Guess I'll just tape up my toe carefully and have another walk tomorrow.