Expression help

[#1]

Hi all,

I have a list of alphabetical and numerical values in axis. like this

A C C E F FL HO 1 2 3 4 5 10 .. I need to sort it like this E A 1 2 3 4 5 10 FL HO. Please look at the screenshot for more clarity.

Thanks in Advance

Sai.

[its_anandrjs]

Hi,

If there is few values you can try this way write expression in the Sort properties >> Sort Expression

Match( FieldName, 'E', 'A' ,'1' ,'2' ,'3' ,'4',' 5' ,'10' ,'FL' ,'HO')

And unselected all option

Regards

Anand

[sarfaraz_sheikh]

Hi

you need to put your sort order into the expression defination of sort tab....try like below

WilMatch(FieldName ,E', 'A' ,'1' ,'2' ,'3' ,'4',' 5' ,'10' ,'FL' ,'HO' so on......)

Regards

Sarfaraz

[aveeeeeee7en]

Hi

Right Click on Chart > Go to Properties > Sort > Check Expression > Write this Expression > Dual(YourFieldName,Match(YourFieldName,'E','A','1','2','3','4','5','10','FL','HO'..........)) > Ascending.

This expression will sort the way you want.

Regards

Av7eN

[#5]

Thanks All .