Sort the Dimensions dynamically

[Anonymous]

hi,

I have a dimension named empname and values in expression.

empname    values

     ram          100

     par           300

     peter          50

     steven      120

     bass          30

I need to display the empnames as follows.

empname     values

   steven          120

   bass              30

   peter              50

   ram              100

   par               300

obviously i cant sort the names as above using sort tab in any of the objects, How do i display the above , (i.e) i have to sort those names dynamically. Need your help

Thanks

[marcus_sommer · Accepted solution]

If you didn#T want an aplhanumeric sorting you need to define your sort-order within the script - to adjust the load-order or with an additionally sort-table - or you could use a sorting expression within the object like:

pick(match(empname, 'steven', 'bass', ...), 1, 2, ...)

- Marcus

[Anonymous]

Thank you. I used in a sorting expression in an object. It worked.