Filter

[smilingjohn]

Hi i have a field called cast

Iam taking this field as a filter and i want to display only two values in this how do i do this

currently this is how it looks

I want to show only Sal and Bor in this filter

Thanks

[Or]

Depending on what you want to achieve, you can do this several ways:

1) Filter the data in the original script.

2) Create a second field, Cast_Filter, with the syntax if(Cast = 'Sal' or Cast='Bor',Cast) as Cast_Filter and use that. This is usually the recommended approach if you can't filter the data in the original script.

3) Use a similar expression in your list box (Set it to <Expression> first).

[Anil_Babu_Samineni · Accepted solution]

May be use, Expression for Cast

=If(Match(Cast,'Sal','Bor'), Cast)