List Box Object Issue

[#1]

I have a list box for Year and I have 10 Years in the list box like 2015,2014,2013,2012,...............etc.

I would like to display only 3 years (2015,2014,2013). I still want the data for all the years but just for  list box I need only 3 years.  So the end user will not be able to select anything beyond 3 Years. 

Is that doable and how can we do that

[sunny_talwar · Accepted solution]

Try this:

If(Match(Year, 2013, 2014, 2015), Year)

Alternatively this should also work:

=Aggr(Only({<Year = {'2013', '2014', '2015'}>} Year), Year)

[#3]

I wanna use dynamic year, like MAx Year, MAx(Year)-1 etc

[sunny_talwar]

May be this:

=Aggr(Only({<Year = {'$(=Max(Year))', '$(=Max(Year)-1)', '$(=Max(Year)-2)'}>} Year), Year)

[#5]

Sorry I meant Year(Today()), Year(Today()-1 etc

[sunny_talwar]

Try this:

=Aggr(Only({<Year = {$(=Year(Today())), $(=Year(Today())-1), $(=Year(Today())-2)}>} Year), Year)