How to deactivate the space of unselected values in list boxes?

[#1]

Hi,  I have more than 10 list boxes in my dashboard, when I select Country of 'INDIA', then I am able to see the states belongs to that and rest has been grayed. I don't want to see the gray space if I do select Hide Excluded.  My intention wants to see only corresponding values not grey or select Hide Excluded.  Is there any possible way to achieve this??  Thanks,

[Gysbert_Wassenaar]

Use an expression for the listbox instead of the field name. Instead of Myfield you'd use aggr(MyField,MyField)

[#3]

I did, but instead of Gray now its coming White I have deselected Hide Excluded.  If I want to avoid the that White, then I will have to choose Size to Data option right??  Any other way implementation.  Thanks,

[rwunderlich]

Nice tip about the aggr(field, field). Didn't know that one.

-Rob