sorting in alphanumeric order

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: sorting in alphanumeric order

Anil_Babu_Samineni — Wed, 20 Sep 2017 15:30:44 GMT

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