summing hours by project ID

I'm trying to create a new column that turns the first table into the second table. I'm trying to sum the hours that were done on each project.   Here is my code so far: NewColumn = sumx('Test Tabl...