Sort a MDX Dataset by Multiple Criteria

Recently I work on a SSRS report that needs a parameter to return a set of user to be selected as the filter for the report. The list of user has to be sorted by Department Code and User's name.

In MDX, sorting a dataset based on one criterion is directly supported through the Order( ) function. However, it doesn't support multiple criteria for sorting explicitly. In order to sort the dataset with multiple criteria, some tricks will be needed to complete the task.