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.