Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, is it possible to customize a listbox to display 3 latest months inside a "normal" listbox
an example where oct-2013 the current month.
Oct-2013
Sep-2013
Aug-2013
--------------
Jan-2012
Feb-2012
Mar-2012
...
aug-2013
sep-2013
oct-2013
Use list box expression like: =Aggr(If(rank(MonthName)<4,MonthName),MonthName)
PFA
thank you for your reply. And I can see that my question was not well described, sorry about that. But I would like to know is. After AUG can I then show the remaning months. Created a photo from your example that might show a little better how I whish i could get it. Imagine that this is one listbox and not one ontop of another:)
Sort on expression =If(Rank(MonthName)>3,Rank(MonthName)-10,Rank(MonthName))
PFA