Dimension Custom Sort

[Ruzette_Go]

Is there any way to custom sort the Dimension in not alphabetical order besides of adding extra spaces in the label name (label: “                    dimension name”)?

I tried this in lookml:

dimension should be: 

B

A

C

dimension: dimension_sort {

type: number

sql: ${table}.dimension_sort

oder_by_field: sort
}

dimension: sort {

type:number

sql: case when ${table}.B = ${table}.B then 1

when ${table}.A = ${table}.A then 2

when ${table}.C = ${table}.C then 3

else null

end;;

}

but it didn’t worked, dimensions are back to alphabetical order.