You can't use other columns like that in expressions. You have to use the fields in expression. Here I create three columns D,E and F that all three use field Sales in an expression. F calculates the sum(Sales) divided by the overall average of Sales over all dimensions.
F: sum(Sales)/avg(total Sales)
I hope this helps you figure out how to achieve what you need.