Sorting Stacked Chart

[#1]

I have a chart with the following Dimensions:

My Expression is: 

Sum(FreightCosts)

My graph looks like:

I want it to sort the lowest value on top (Misc) and Highest on bottom (Freight).  I have tried everything and can't get it to work.

Please help.

[MarcoWedel · Accepted solution]

Hi Amanda,

one solution might be to use Sum(FreightCosts) as a sorting expression as well. The order can be defined once for the whole chart, not per bar though, i.e. the order is defined by the total costs per category:

hope this helps

regards

Marco

[#3]

The SUM Freight function still isn't working.  Here is what it looks like now:

The Red section (Misc) is now all over the place.

[ashfaq_haseeb]

Hi go to sort tab and select sort by y value ascending for both dimensions.

Regards

ASHFAQ

[morganaaron]

Hi Amanda,

Try using =Rank(Sum(FreightCosts)) for the expression for Category in the sort tab and set to Ascending.

[#6]

Okay... so the Sum(FreightCosts) is actually working.  I reviewed my data, and apparently some of my freight (misc) is negative. 

SO, it is sorting correctly!

Thanks All.

Amanda

[#7]

Amanda i see that you are new here so please take the time to mark Marco's answer as correct answer