Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Chart Properties>>Sort>> (Choose the Dimension) Sort by EXPRESSION>>(Set your expression)
May be this
Rank(-Expression)
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
use just it in the expression box
[Rank Mac] + [Rank iPad] + [Rank iPhone] + [Rank Watch] + [Rank Acc App]
disregard "CD_SALA"
rank(-amount)
hi
I already put the expression but it underlines me in red it seems that it is not allowed to use that way.
hi Monica,
num(Rank(-[Rank Mac]+[Rank iPad]+[Rank iPhone]+[Rank Watch]+[Rank Acc App],1))
More like this
Num(Rank(-([Rank Mac]+[Rank iPad]+[Rank iPhone]+[Rank Watch]+[Rank Acc App]),1))
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.