How can I generate the Total column from the below screenshot?
As you can probably see, it's a total of all of the Quantity values for a given Order number. From which I can derive Proportion, and that part's nice and simple once Total is filled.
I think there's probably a simple solution but I can't my head around it.
