button ranging values

[#1]

I need a button, if i click on button , SalMonth values of Jan,feb,Mar,apr,May  should get selected 

if i clear then teh SalMonth filter should have no selections

please do not hardcode the values.

please suggest me on this

[tresesco · Accepted solution]

Search string: (Jan|Feb|Mar|Apr|May)

PFA

Ohh, you wrote not to hard code. Then what is your logic ? First five months?

If, so, you could try search string like:      ='('&Concat(If(Month(Date#(SalMonth,'MMM'))<=5,SalMonth),'|')&')'

[#3]

Thanks Tresesco for the response

I need a logic like --> values in the list box should have numbers like 1,2,3,4,5,6,7 along with the data.

then based on the values it should take the selections

some thing like, Index,pick or firstsortedvalue which give the number for the values.

[tresesco]

Even that listbox numbers would not be required, please check above the updated comment and app. And if you insists of that numeric filed use, try search string like:

='('&Concat(If(Eid<=5,SalMonth), '|')&')'