Sum values in a column if values in another column are equal

[Anonymous]

I have some data that I would like to sum, but only if the values in a different column are equal. For example:

Name        Value1         Value2      Value3

Ann              2                  5               1

Ann              1                  2               3

Ann              4                  1               4

Bob              3                  4               2

Bob              1                  1               5

Cat               5                  2               1

Cat               2                  3               1

So the value column would be summed if the name column is the same. The new table would look like this:

Name   Value1    Value2   Value3

Ann           7           8            8

Bob           4           5            7

Cat            7           5            2

I have over 500 names to do this for, so I can't do a measure for each name individually. Any thoughts on this?

Thanks!

[amitchandak · Accepted solution]

@Anonymous , if you put Name as unsummarized and value 1, value2 and value 3 as sum in table visual, you will get same