Hi All,
I have a table with DepartmentId,DepartmentName, DepartmentParrent
I used Hierarchy query and get Department in 5 level.Department1,Department2,Department3,Department4,Department5
I want to user Department3 with condition in dimension. if(Department2='organization',Department3)
I want to show dimension in a sort order. but it does not work. what could I do ?