Sorting site names as per active order

[rajendraongole1]

Hi 

i have few list of sitenames which i need to sort the order of the sites which is active.

List:

Germany

Norway

Milan

China

Finland

south africa

Venezula

How to get the above order?

Please suggest.

Regards,

Rajendra

[DouweMeer]

Not sure if this 'solution' is the solution that matches your problem...

But under the tab 'Modeling' you can find 'sort by column'. If you would use this, the alfabetical order will be overruled by the sort that you request from another column. 

[rajendraongole1 · Accepted solution]

Hi

I have resolved it.

Created one new column and applied switch statement with 1,2,3,4,5,6.. and so on. and i have sort the column by sort by column mode. able to get the visual as per requirement.

Thanks.

Regards,

Rajendra

[DouweMeer]

Cheers