Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a listbox with Year values: 2010 - 2017
I just want to show the values for the last 24 months. Therfore I use:
=Aggr(Only({<Jahr={"=Jahr>= $(=Year(MonthStart(AddMonths(Max(Today()),-24))))"}>}Jahr),Jahr)
This works as expected. I now see only the values 2015-2017
But when I select a Year value, let's say 2016, only 2016 is displayed in the listbox. Is there a way to show 2015-2017 values and only highlight the selected one green (like the standard behaviour)?
Thanks!
Nihal
try using IF rather than aggr() like:
If ( Jahr>= $(=Year(MonthStart(AddMonths(Max(Today()),-24)))) , Jahr)
try using IF rather than aggr() like:
If ( Jahr>= $(=Year(MonthStart(AddMonths(Max(Today()),-24)))) , Jahr)
Thank you!