I may be missing something, but what is the need for UNIONing here? If you have the KPIs in place, why can't they be straightforward pulls into your matrix?

Sorry if I misunderstand the need ...

Bill