6 Replies Latest reply: Nov 29, 2012 5:10 AM by llxq_yoyo

# sort the dimension

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

• ###### Re: sort the dimension

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

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

• ###### Re: sort the dimension

Hi,

Hope attached file helps you.

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

Regards,

Jagan.

• ###### Re: sort the dimension

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.

• ###### Re: sort the dimension

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.

• ###### Re: sort the dimension

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

• ###### Re: sort the dimension

no it's not working.

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

An match methos is ok.