Take number values from one Drop down and get sum to display as a column called Total in my view

Take number values from one Drop down and get sum to display as a column called Total in my view

Can someone please help?  I went over this a few times but didnt get any real direction.  Thank you in advance!!!!

I have one drop down called Weight

The values are 1, 2, 3

Each time the form is submitted, it places a 1, 2 , 3 in the Weight Column in my view.

I would like a column call Total and have the sum of the Weight Column.  I can then group by User Name to see the Total from Weight values by user.

Please Help!!! I know that you can not use the add sum feature with drop downs but only numerical fields.

I can give someone access to my forms.

Thanks!