In group by clause, you should include all the columns present in the select list that are not aggregated.

So, in this example include all the columns in the group by clause except Sum(Value).