Sorting D-List Cognos 8.4

[mbrassfi]

Hey I have a d-list of employees, that I have to sort manually right now. The reason being is that it is a ridiculous unique string that needs to be sorted in a few different ways.  there are three parts - Department_Unique Personell Code_Lastname,Firstname.
This list is updated monthly, and any change that occurs sorts them in a different way.

it needs to be sorted on Department first (Done, easy)
Then it needs to be sorted on last name

This             needs to be This
10_55_Smith,Jerry           08_88_Besley,Craig
11_20_Adams,Sam          10_55_Smith,Jerry
08_88_Besley,Craig         10_20_Zach,Jenny
10_20_Zach,Jenny          11_20_Adams,Sam

[mbrassfi]

WOOPS, didnt notice, the middle number is unique. two people should not be 20, but the rest of the example is correct.

[redmist]

how about you create 2 data items (think you can use intr to get this) from the name, one for dept and other for last name. Then in the properties of the list use both of these for sorting