Drilled down data sorting does not work properly. Why?

Drilled down data sorting does not work properly. Why?

Try the following steps: 1) For child level drill down, remove the 'Order by condition for the measure 2) To get the first column sorted in ascending order, Set the 'order by condition' as 'ascending' for department_code level in the datamodel.