reg-sorting in straight table

[#1]

Hi iam getting error is sorting in straight table and i have to get the names of correctly under BU COLOUMN.

Bu

ethical

diabetes

oncology

promoted

chc

  but iam getting oncology

                         ethical

                         diabtes

                        promoted

                          chc

and i have given Ascending in the sort tab  and give expression as Order_BU.

IN THE UAT AND DEV ENVIRONMENT THE ORDER IS CORRECT BUT IN PROD THE ORDER IS DIFF...CAN ANYONE HELP ME OUT.

[#2]

could you please share the sample app.

[#3]

i have attached the screen shot

[amit_saini]

Rao,

Try this in your sort Expression:

Dual(BU,Match(BU,'ethical', 'diabete', 'oncology', 'promoted', 'chc'))

Second option:

Create Inline table like below and call BU_New filed instead of BU

Load * Inline [

BU , BU_New

Oncology ,ethical

ethical ,diabtes

diabtes  ,Oncology

promoted  ,promoted

chc  ,chc

];

Thanks,

AS