Not sure what update you're expecting. Your issue is that your weight field is outside the aggregation, which means that if there are multiple unit weights (as is the case in a total row), it breaks. You need to move it inside the aggregation. If you get a result that is different from the one you expect, there may be something wrong with your data model, but since you haven't specified anything regarding that, it's impossible to say.
