Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Morning..
I am facing one issue where i have list of Years from 2000 to 2015 in List Box Properties and I wanted to display only maximum or recent 3 years on in List Box.Can anybody help me to resolve this issue.Thank You !
Hi Prasad, to show the recent 3 years in a list box you can use:
=Aggr(Only({1<YearField={'>$(=Year(Today())-3)'}>} YearField), YearField)
Thank You Ruben .It works for me.:)