How to use "ORDERBY" when "Column_Type" is "Text"?

[Genki_Tokyo]

■現状

列の種類：参照

推奨値：ORDERBY( select(City_Table[id_City],[country_name]=[_thisrow].[country_name]), [id_City],false)

参照された値は、仮想列の [City_name] として使用されます。

■こんなことをしたい

列の種類：テキスト

希望の値：City_Table[City_name]

条件：[国名]=[_thisrow].[国名]

並べ替え：都市_テーブル[id_都市]

翻訳ソフトを使って質問を日本語から英語に翻訳しているのでわかりにくかったらごめんなさい。
ご協力ありがとうございます。

[WillowMobileSys]

Translated to english:

Current status

Column type: Reference

Recommended value: ORDERBY( select(City_Table[id_City],[country_name]=[_thisrow].[country_name]), [id_City],false)

The referenced value will be used as the virtual column [City_name].

■I want to do something like this

Column type: Text

Desired value: City_Table[City_name]

Condition: [Country name]=[_thisrow].[Country name]

Sort by: city_table[id_city]

Is your intention to get a list of City Names sorted by [id_City] and filtered by country?

The next question is where do you intend to use this list?  If it is just as dropdown choices then you likely have everything needed.  If you need to display that list somewhere else, then you may need to add additional columns depending on where that is.

[Genki_Tokyo]

Thank you for contacting us.

Is your intention to get a list of City Names sorted by [id_City] and filtered by country?

→That's right.

The next question is where do you intend to use this list?

→I would like to use it for a simple customer list.
　This is to simplify input.

　If I use "ref", it will be difficult to see the relationship, so I thought it would be better not to use "ref".

Thank you for your support.