Need help with a calculated column

Hi, I am looking to group two columns and find the sum of result, as given in the table below. I hope we can use Summarize() to acheive this , but  that would create a new table and I dont want the...