sorting in alphanumeric order

[#1]

Hi,

I have two drop downs, one with Countries and the other with Product codes.

I need to sort the product codes in alphanumeric order.

We also have sectional access in which specific users have access to only one specific country.

When i sort the product codes in alphanumeric order, it appears in order only to those who have access to all the countries.

But for country specific users, the sorting fails.

Is there a way to sort the product codes so that it do not fail for country specific user as well as for those who have access to all countries.

Example :

Input file:

Country                      Product Code

Canada                       Z168

Russia                        Z437

Canada                       X181

Russia                        A284

Canada                       A123

I need the output something like this :

Country                     Product Code

Canada                       A123

Canada                       X181

Canada                       Z168

[Anil_Babu_Samineni]

When you say output you can use in script

Load * From Table where Country Like 'Canada';

Front end

If(Match(Country, 'Canada'), Country) // Calculated Dimension

Only({<Country = {'Canada'}>} Country) // Measure