Sorting Column in Bar Chart in QlikSense

[niha]

Hello,

I need the 

i need the Total CCS to be in Last and different color than other. 

I want the second bar : Total Others CSS is to be in Last and in Grey Color .

here is What the expectation is:

Here the Grey one is Total Others and Blue col is for current year which is sorted by Paid amount. Please suggest!

Regards,

Niha

[Channa]

sorting now it is based on measure..change to dimension..

if possibles share app

[niha]

Thanks. Yes I did sorting with Dimension and it comes now like follows. I have two measure say Current Amount paid, Years ago Amount paid. One Dimension CSS. So Basically it is asking for Top 5 Current Amount paid and should be Ranked High to low. But the Total Other CSS  values should be separated from this . This should stand only as 6th values with different col on last.

what I want is:

1. The 'Total OtherCSS'( which is a value is CSS dimension) should be Grey Color and should be placed in Last.

2. The other 5 values should be sorted numerically Desc according to Current Paid.