Restricting/hiding list box values

[#1]

Hi all

I have a YEAR dimension like this :

Year ( Booking_Date) as Year

Field Values are 2006,2007,2008,2009,2010.

When I add this list box to the sheet, if I want to see all year's accept 2010 in list box …how I can do this ??

                                                  (i.e 2006,2007,2008,2009)

Many thanks

[#2 · Accepted solution]

Shariq,

Go to the List Box properties and under the Field column dropdown, Select Expression.

Add expression as:

=aggr(only({<Year-={2010}>}Year),Year)

Please see the attached sample.

Hope it helps.

Regards,

-Khaled.

[#3]

Hello everyboy,

I have a similar question as Shariq.

I have a listbox with 30 or so values which I want to limit to 20. This means that only these 20 values should be pre-selected. Is this possible?

Thank you!