Sorting!!!

[#1]

Hi everyone, is there any expression to sort the fruits according to its ID without displaying the 'ID' column?

For example :

ID	Fruits	Number of items sold
1	Apple	2
2	Orange	4
3	Pear	56
4	Strawberry	7

BUT, i would like to sort the fruit's ID in custom order without displaying the 'ID' column shown above.

Fruits	Number of items sold
Pear	56
Strawberry	7
Orange	4
Apple	2

[#2]

Hii

Go to

Chart Properties -> Sort -> Expression

then write : =num(ID)

Make it Ascending - If you required to sort 1 ,2,3,4,  Sequence...

For Your Reference I attch Image

[Kushal_Chawda]

see the attched one

[shree909]

Hi ,

goto the properties--> sort

for fruits  write expression as   

wildmatch('Fruits ,'pears','strawberry','orange',apple') and select the ascending order for the expression.