Multi Box Filters sorting and shrinking

[#1]

Hi,

I have enabled the sorting option of 'Sort by State - Ascending' and also i have checked 'Hide Excluded' option. So i m getting only the possible values in the filter in ascending order. But i am also getting empty rows after the possible values in the list.

Is it possible to truncate or shrink those empty rows. Pls help me.

Malathi

[m_woolf]

Try:

aggr(Fieldname,Fieldname) as the expression

[#3]

Hi,

Thanks for your inputs. Unfortunately it is not working.

Could you help me with any other solution?

Regards,

Malathi

[m_woolf]

When I use the expression:   =aggr(Fieldname,Fieldname)  instead of the Fieldname, the Multibox does not show items that are excluded. It shows only the possible items.

Can you attach a screen shot of your expression and what the multibox looks like when pulled down?

[#5]

When i tried the options given by you, i m getting the drop down values as above,

Also i have disabled the 'Hide Excluded' option in the presentation.

I want only the possible values in the filter and the drop down length should shrink to possible values.

[m_woolf]

I am not talking about putting the expression in the sort tab.

In the General tab, use the expression instead of displaying a field.

In place of the Area field use: aggr(Area,Area)

[#7]

Thanks a lot. It really worked well. But i could not understand the logic behind it. Could you please explain me.