List Box

[#1]

My data is shown below within my dashboard.  I'd like to create a list box that would only read the first letter of the data field and not show duplicates (A,A,A,B,D).  In this case the list box would show my choice of (A, B and D).  When clicking on A, I see all the fields that start with the letter A.

A 01-01-01

A 01-01-02

A 01-01-03

B 01-01-01

D 01-01-01

Any ideas on how I can perform this?  I'm unsure if a list box is the best object to utilize.

Thanks,

Rob

[calvindk]

One way could be creating a data island, with the optionvalues you want in your listbox, and then upon selecting have a trigger select in field.

[Oleg_Troyansky · Accepted solution]

You can create a list box with a calculated expression, something like Left(MyField, 1).

Oleg Troyansky