Problems with sorting in a bar graph

Mattwjones
Mattwjones ⚪️
edited January 4 in Charting

Hey there,

I have encountered an issue when trying to display some sales data, I am trying to display quantity sold by product with the highest value on the left.

We sell our products in 4 regions (4 colours) and for some reason the sorting is only being done on 1 region and completely ignoring the sum of all 4 regions.

Is anyone able to offer assistance?