Sort value in a chart and put "Other" at the end

[#1]

Hi,

I've a chart with several value in dimension, takes for instance :

Dimension	Value
A	1
Other	1
C	1
D	1
B	1

I would like to sorting values in order to have :

Dimension	Value
A	1
B	1
C	1
D	1
Other	1

Infact, I would like to put "Other" at the end. I can't manage the script, so I have to find a solution into properties of chart.

I can't use the alphabetical order, I believe I have to choose the expression order but I have no idea about which function I can use.

Does anyone has an idea ?

Thanks,

Regards,

Marine Le Trionnaire

[#2]

Hi,

Thanks for your answer.

I tried this expression and it's OK, that was the expression I would like to create.

Thanks,

Regards,

Marine Le Trionnaire

[#3]

Thanks for your answer.

I tried it, it seems to be OK. Like the match function I put WildMatch(Dimension,'Other') and I add an alphabetical order and it's OK.

Regards,

Marine Le Trionnaire