custom sort dimension - number

[#1]

hi i would like to have a custom sort function on the dimension itemnumber

so that all the numbers beginning with 9 come first in the list.

i have tried the following ;

=match(left,Itemnumber,1))

Best,

Bradley

[michael_maeuser]

i would create a field in the script,

if(left(itemnumber, 1)=9, 1, 2 as xxx

and then sort by that field ascending

[swuehl]

Maybe like this:

= -match(left(Value,1),9)

or even just

= -left(Value,1)

as sort expression. But how do you want to sort the other values?

[christophebrault]

Hi,

if(Left(Value,1)=9,-1,Value) and sort ascending.