Sorting a Stacked bar chart based on total Value

[Anonymous]

I have this Stacked bar chart in my Dashboard where I have to sort the chart based on the values ie. 67.44,94.83,112.40....

However, the problem I'm encountering is, It's getting sorted either on the basis of First Expression value (the light colored part) or based on the Dimension.

Would be helpful if someone can throw some light on this.

Thanks.

[Anonymous]

Thanks Liron and tresesco‌ That was really helpful. rangesum makes it much easier.