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.
Any ideas on how I can perform this? I'm unsure if a list box is the best object to utilize.