Summing values of a dimension based on criteria of another dimension

Hi all,

I have been stuck on this for longer than I would like. I have a table with various dimensions. One dimension lists names. The names are repeated sometimes. Another dimension provides a number for each name. The corresponding number for each iteration of a name may be different.

I want to take a sum of the numbers for each name. But I’m not sure how. Something like this.