Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
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!