Adding up values based on ID

RoxanneR

Hi 

I am struggling with this scenario

What I want to do in is: Add all of the values in the "SUM Value" column for each unique combination of General ID and ID.

The output should look like the "SUM values" column, where all the values for each unique General ID and ID would be added together. 

The columns Column 1, Column 2, Column 3 shouldn’t be summarized but I will also need them to be included in the output.

Column 1	Column 2	Column 4	General ID	ID	Value	SUM Value
Description	Country	City	10	101	0
Description	Country	City	10	101	20	20
Description	Country	City	12	102	30
Description	Country	City	12	102	30	60

I tried Summarize + Join but unsuccessfully because after JOIN I had this result -which isn't correct

Column 1	Column 2	Column 4	General ID	ID	Value	SUM Value
Description	Country	City	10	101	0	20
Description	Country	City	10	101	20	20

Second question would be how can I summarize the values in SUM Value column without loosing the first 3 columns?

CoG

If the 2nd table in your problem description is wrong, how do you know which row to add the SUM Value to? Is it always the last row? or can it be any row as long as it is only one row (for given [General ID] and [ID])?