Sort by aggregated values in bar chart

Hi team! Is there a way to sort by aggregated values in bar chart? The result wanted is US as the top bar then US->CA, US->CA->MX, CA->US and US->JP I enabled descending in values, but still the output is not what I wanted.

It looks like you’re also grouping by date.

If you take off the date, does it work?

Thanks Max, but I need to add date a segment. Removing date doesn’t the change the alphabetic order in the chart.

@Jing - When I tried to replicate the issue at my end, I could not as I was able to get the data exactly how I wanted i.e. sorted by value. Can you please share the sample dataset so that I can try to replicate using that? Please see the snapshot below to see how I am getting the graph.