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.

[#2]

Select sort tab under the chart properties and check Y-value option keeping Ascending order in selection.

[lironbaram]

hi

in the chart properties

go to the sort tab

check the box sort by expression

and insert your expression in the whit space

select sort in descending order

[Anonymous]

Thanks for your reply. I tried that already. However that result yields a chart like this

You can clearly see 3 bars with 2 stacks are not sorted.

[Kushal_Chawda]

Go to sort sort tab.

In expression, put below expression

=(Expression1+Expression2)

and select descending

[Kushal_Chawda]

please share the sample if possible

[lironbaram]

well

this method works for me usually

is your dimension a field or calculated ?

if you put the expression you used to sort in a table with the same dimensions do you get the correct results?

[Anonymous]

You were spot on Liron.

1. Field is used as Dimension here.

2. However, when I checked the expression in a table those values were missing.

Reason I can guess is, one of the expression(among the 3) I used is not associated with that field value. Question is, Is there any hack to get it sorted along with other values?

[tresesco · Accepted solution]

Instead of '+' addition use RangeSum(), like:

RangeSum(Exp1, Exp2, Exp3)

[lironbaram]

hi

can you post your expression ?