Top 10

[emteam162]

Hi All,

I want display top 10 and how have more then 15 items

dim	item
a	25
b	10
c	12
d	78
e	16
f	15
g	67
h	3
m	9

i want this

dim	item
d	78
g	67
a	25
e	16
f	15

Many thanks for your help

Said

[Anonymous]

Hi,

You can go to properties->Dimension Limits. You can then check the "Restrict which values are displayed. . ."

You can then restrict which values are shown

[#3]

right click the object -> dimension limit -> show only largest n values

[migueldelval]

Hi Said,

Yopu only need to go to tab (Dimension limits) and check in the first option.

Regards

Miguel del Valle

[emteam162]

Yes, but is not enough for me

i want dispaly the best suppliers (10)  who have delivered more than 15

[#6]

Use expression to sort out suppliers who have delivered more than 15, then go to dimension limit -> show only largest n values  Hope it works!

[emteam162]

can you give me exemple please

[arasantorule]

Hi,

You can use the expression to count the no of products delivered  and also restrict to more than 15 in the condition.

Then in dimension limit show first ten values. Now sort the "no of product delivered" to descending.

Thanks,

[varshavig12]

dimension

= dim

expression

= if(Rank(item)<=10,item)

[emteam162]

doesn't work