Steve,
Thank you kindly. The latest is, you righted my ship with your one sentence:
"What you are looking to do is a straightforward crosstab, with person as your rows dimension, group as your columns dimension, and value (your numeric column) as your fact."
...as soon as I read that I knew...