I am using the Ad-hoc tool. When I add a filter one of the values for the field does not display in the list of choices. When I do not filter the results I can see the records with this value in the field. I don't think it will matter but the value is a code with the actual value 'CTA' - all other values show up in the filter list. Any ideas why this value is not showing up?
Thanks!