the "7, It's fashion" value which is combination of ID and Name. The formula like: CONCAT(TRIM(CAST("Item As-Is"."Subclass Number" AS char)), CONCAT(', ',TRIM(CAST("Item As-Is"."Subclass" AS char)))).Sorry I couldn't understand what you mean , I expect the selected value is ID and displayed value is "ID, Name", the…

Hi asim, How can I do like that?

Thanks @Gianni Ceresa, my version is 11c. It's not support features to do like that.

I appreciate your help in advance. But I didn't find out the feature like screenshot: