sort the dimension

[#1]

I want to sort  the dimension in ascending order.

The values of dimension are  (varchar type) : 0,1,2,3~19,20+

I've try to write expression to sort these values.But it didn't work.

Anyone can help?

Thank you

[#2]

IF(yourfield < 3, yourfield, IF(yourfield = '3~19', 3, 4))

Put the calculation in sort by Expression under the Sort-tab

[jagan]

Hi,

Hope attached file helps you.

Select Chart Properties -> Sort -> Select Sort by -> Text and uncheck others.

Regards,

Jagan.

[#4]

The 3~19 ia an interval, so the result shoud be:

0

1

2

3~19

20+

Numerical sorting doesn't work here, need to be an expression.

[jagan · Accepted solution]

HI,

Do the following

Select Chart Properties -> Sort -> Select Sort by -> Expression

=Match(DimensionName, '0', '1', '2', '3~19', '20+')

Hope this helps you.

Regards,

jagan.

[#6]

Or just do as i wrote in the first response: IF(yourfield < 3, yourfield, IF(yourfield = ',3~19', 3, 4))

[#7]

no it's not working.

The result is  0 ,20+, 1 ,2, 3~19

An match methos is ok.

And Inspired by you ,my solution is if(Logins = '20+',4,if(Logins = '3~19',3,Logins))

Thank you all!