Group by Sum adds all values in each group.
Result (Group by Sum):
Explanation
East: 100 + 200 = 300
West: 150 + 250 + 100 = 500