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.

ec245bcc-5220-41d3-9b54-67b3f15786c2.png
0 1 129
1 REPLY 1

Hello, I have the same question and found this thread, maybe it will help. 

https://community.looker.com/technical-tips-tricks-1021/subtotals-with-table-calculations-30771
Top Labels in this Space
Top Solution Authors