Static choice defined in value prompt

Requirement:

I have 4 countries in my database as USA, UK, INDIA, and CHINA. In value prompt control list, I want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names (USA, UK, INDIA, and CHINA). When I click on WESTERN_COUNTRIES I should get USA, UK respectably.

Solution:

• Develop values prompt name of the prompt : 'Countries'
• In Static choice define 2 values like : WESTERN_COUNTRIES, ASIAN_COUNTRIES
• Use value of the prompt : [Country] IN ('INDIA','CHINA')
• Display value of the prompt : Eastern Countries
• Query explorer open query and apply filter.
• In the Expression Definition:
• #prompt ('<prompt parameter>', 'token', '<default filter>')#
• #prompt ('Countries', 'token', '[Country] in ('USA', 'UK', 'INDIA', 'CHINA')')#

 Thank you.