Lynn your SUM plus CASE solution works well too. Thanks.
It takes me a while to integrate a solution as CTEs are so hard on my brain for some reason. It is really the hardest part to provide DDL that corresponds to my problem closely, but because it doesn't entirely, I still have to fidget with solution.
But, that puts me leaps and bounds ahead and thank you all for your teaching. I am eternally grateful for the goodwill on this forum. It's ramifications go far beyond the immediate problem.