This content has been marked as final. Show 7 replies
I have a list box which has values from 2008 to 2013.
I want the listbox to display current year and previous year ( ie 2012 and 2013)
I know this can be achieved using the expression inside the list box.
My requirement is I don't want to hardcode year in order to pick top 2 values.
I tried using the following expression inside the listbox
if (year=max(year) or year=max(year-1))
But the thing is when I click on 2012 in the list box ,it show 2011.
Is there a way this can be achieved without hardcoding year values ?