How to show selected values for a field in a list box?

[Anonymous]

Hi,

I have a Filed name "ListOfChanges" in the List box as a filter. The field has many many values under it from which I just need to show a few.

So how can I achieve this? Showing only a few values for Selection instead of ALL the values under the particular field.

TIA

[swuehl]

You could create a calculated field like

=If(Match(ListOfChanges,'Change1','Change2'), ListOfChanges)

(enter in <expression> field on general tab)

[Anonymous]

No, Doesn't Work, No change.Attaching a Screenshot of where I entered the Expression. Hope I am entering it at the right place. I entered the expression at two places but no change.

[Anil_Babu_Samineni]

You can create like this too

=If(Wildmatch(ListOfChanges,'RequiredValue1','RequiredValue2','RequiredValue3',....), ListOfChanges)

[Anonymous]

No. Still able to see all the values under the field name.

[swuehl]

Select <expression> from the field dropdown on general tab, and input the calculated field expression.

[Anonymous]

Yup, works. Thanks a Lot