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