How to sort by multiple columns

Q&A
, ,
1

Hi Team,
Do you know how to sort by employee id and Training Title in the example below? First sorting is based on employee id and second sorting based on Training Title, I want “Driver Trainer Pre-Reconnect Knowledge Assessment” above “2.tDriver Trainer Post-Reconnect Knowledge Assessment”. I have tried the ifelse and rank function, but it doesn’t work so far.

Training_title
Training_title1067×284 28.2 KB

DT_curriculums

1 Like
2

Hi @Li_Yang - Can you please create a calculated field with below logic and then do the sort on that field

concat(toString({Employee ID}), {Training Title})

See the below screenshot

image
image1456×771 97.7 KB

Regards - Sanjeeb

1 Like
3

It works,Sanjeeb! Thank you so much!

1 Like
4

Thank you @Li_Yang . Please mark the require response as solution so that it can help other community members.

Have a great weekend.

Regards - Sanjeeb