Default to current year but enable user to select from year dropdown list as well

[Abhi999]

I want to show current year by default and then want a option to to select required years in waterfall chart.i tried below but not working Re: Default to current year but enable user to select from year dropdown list as well

 ,[JDE.Year] = {$(=RangeMin(max([JDE.Year]),Year(today())))

[Taoufiq_Zarra]

can you share a sample data ?

[jonathandienst · Accepted solution]

With that set expression, the user can make a selection of JDE.Year and the value will change to that year, providing it is not more than 2020 (year(today()).

[Abhi999]

Thanks it is working fine.