Secondary sort of a stacked bar chart

[Anonymous]

Hi all

I have a stacked bar chart that I can´t sort the way I want to. Equal values they are sorted alphabetically but I want them sorted according to which one scores highest in the dark blue field.

I sort using this script:

(Numericcount(L_$(Year)_2)+Numericcount(L_$(Year)_1))/(NumericCount(L_$(Year)_1)+NumericCount(L_$(Year)_2)+NumericCount(L_$(Year)_3)+NumericCount(L_$(Year)_4))

And I want to do a secondary sort for equal values using this:

(Numericcount(L_$(Year)_1))/(NumericCount(L_$(Year)_1)+NumericCount(L_$(Year)_2)+NumericCount(L_$(Year)_3)+NumericCount(L_$(Year)_4))

Any ideas?

/Måns