Create a new table with the sum of values of another table per ID

[Anonymous]

I need to have the sum of values of a table in individual rows per id in a separate table. Example:

Original table:
ID     Value

1     5

1     2

1     3

2     2

2     4

3     3

Desired table:

ID     Sum of Values

1     10

2     6

3     3

How do I manage this?

The reason I need it in another table is because I want to do a relationshipt between the desired table and another table. And when I use the original table, I am getting a many to many relationship, which is not ideal

[amitchandak · Accepted solution]

@Anonymous , you can create a new table like

new table = summarize(Table, Table[ID], "Sum of Value", sum(Table[Value]))