Restrict listbox to view only two months

[Anonymous]

Hi,

I have a listbox that lists my dates as months .General tab > field...  given my month field here.

How should I frame a expression so I can just view max( month) and one prior month .???/

[Anil_Babu_Samineni]

May be use

Match(month, 'jan', 'feb')

[tresB]

Try like:

=Pick(Match(-1,Month=Max(total Month),Month=Max(total Month, 2)), Month, Month)

or

=If(Month=Max(total Month) OR Month=Max(total Month, 2), Month)

[Chanty4u]

try this

=aggr(only({<Month=  {'Jan','Feb'}>}Dim),Dim)

[#5]

Try this

MONTH_YEAR={">=$(=date(AddMonths(date((max(MONTH_YEAR)),'MM-YYYY'),-1),'MM-YYYY'))<=$(=date((max(MONTH_YEAR)),'MM-YYYY'))"}>}

[sunny_talwar]

Try this may be

If(Date >= Max(TOTAL MonthStart(Date), 2), Date)

[effinty2112]

Hi Nitya,

Try this as in expression in a listbox:

=Aggr(only({$<Date ={">=$(=Monthstart(max(Date),-1))"}>}Month),Month)

Make a New Sheet Object \ List Box ...

In Field scroll right down and select <Expression> then enter the above.

Good luck

Andrew