Sort fields based on their values inside multibox

[Anonymous]

Hi all,

I have the following multibox, in which the separate fields represent our business areas.

This is shown as additional info when an opportunity is selected; if the opportunity contains work related to a business area (field), 'yes' is shown - otherwise 'no'. Datacenter Solution and Product Support Services have been added to our CRM system lately, which is why there is not much data related to them (shown at the bottom).

What I would like the multibox to do is show values with 'yes' at the top, 'no' under them and those without much data at the bottom. So I basically want to sort the fields according to their values.

I tried to use the 'sort by applicability'-functionality, but with no luck.

Should the value be 'yes', It would also be informative to change the color of the specific cell. How could I do that?

Thanks,

Juho

[#2]

You can use State or Expression to chnage the sort order in Sort tab.