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

[n1ef5ng1]

sum(TEU)

[#3]

Hi,I would like to sort the fruits's ID in custom order. And, i didnt mention TEU in my question. I think you replied the wrong question.

[priyav24]

Hi,

Go to Properties->Sort

Select the Dimension check the Expression and enter ID As shown in the figure

This will Sort by ID

Regards,

Priya

[#5]

Hi, I would like to do a custom sort. Not just an automatic sort. Is there any way?

[#6]

in script--

load Fruit ,item

resident table

order by fruit asc;

[priyav24]

In this Expression you can customize by giving the suitable expression..

For eg:

Here you want sort by id,So we have given by id...

Like this you can do according to your requirement

[tresesco]

Take all the three dimensions in the table and sort the table on ID, then hide the ID column in the presentation tab.

[MayilVahanan]

Hi

Properties -> sort -> Expression

In that, you give the field Name -> ID, its sor according to it

Hope that helps

[priyav24]

Yes it is.

PFA