rank descending

[gr_eldred]

Hi,

With this function I have managed to get the ranking but I need to start the ranking from the value with the least amount

example:

amount    Rank

5                 2

7                 3

2                 1

8                 4

9                 5

Can anybody help me?

regards

[Anonymous]

Chart Properties>>Sort>> (Choose the Dimension) Sort by EXPRESSION>>(Set your expression)

[sunny_talwar]

May be this

Rank(-Expression)

[gr_eldred]

my expression is as follows:

num(Rank([Rank Mac]+[Rank iPad]+[Rank iPhone]+[Rank Watch]+[Rank Acc App],1))

does not allow to enter expression in sort

[Anonymous]

use just it in the expression box

[Rank Mac] + [Rank iPad] + [Rank iPhone] + [Rank Watch] + [Rank Acc App]

disregard "CD_SALA"

[Monicalingan]

rank(-amount)

[gr_eldred]

hi

I already put the expression but it underlines me in red it seems that it is not allowed to use that way.

[gr_eldred]

hi Monica,

num(Rank(-[Rank Mac]+[Rank iPad]+[Rank iPhone]+[Rank Watch]+[Rank Acc App],1))

[sunny_talwar]

More like this

Num(Rank(-([Rank Mac]+[Rank iPad]+[Rank iPhone]+[Rank Watch]+[Rank Acc App]),1))

[gr_eldred]

Oh very well, if these parentheses were missing. Thank you so much. Thanks also to Monica

One more question in my data I have some repeated values for example

In the Global field I have two records with 81. Is there any way to use an additional condition so that I am not tied?

  the Column that I would use in case of having a serious draw rank iphone is marked in red.