Sorting on data

SiddamS

Hi All,

I have a requirement to sort the table data.

The Table column contains the data as follows:-
EM,LT, IM, EM, MT, IM,LT.

I want to sort these data following sorting oder :-
EM, IM, MT, LT.

could anyone please help to me.

Thanks and Regards,
Swetha.

mwilliams

Hi Swetha,

Create a computed column in your dataSet that sets a value of 1 for EM, 2 for IM, 3 for MT, and 4 for LT. Then, sort using that field. That should do it.