How to get ratio of selected column item

[kaung]

I want to get ratio by dividing SUM(all selected column items[A,C,B,D])/SUM(selected selected column items except last one[A,C,B].
Please check example.
Does anyone know how to solve it?
Thanks,