I work with a lot of dirty user entered data.
I would like to try to bucket all of my results into a cleaner report. Something like:
Report all records where vendor_name contains ‘Agilent’ as ‘Agilent Technologies’.
I can ask for all of the iterations, but I’m having trouble bucketing all of the results into an " as " statement. Is there way to build a customer filter or alter my report?