Rank function for repeated data

[marjan_it]

Hi All

I have a problem in Rank function.

my data i like this :

code	Number	Name
1712	51.11	A
1306	50.00	B
504	50.00	C
1702	48.10	D
1206	47.83	E
1801	47.37	F
505	46.88	G
1517	46.43	H
1212	46.39	I
521	43.75	J

I want to show top 10 Name in text object in sort I use this

=Aggr(if(   rank(sum(Number))=1  ,Name),Code)

It is work for non repeated data but for repeated data its not work. what should I do to show data.

qvw file is attached .

[Anil_Babu_Samineni]

Is This you are expecting

[marjan_it]

No, In my qvw file i explain what I expect

[Anil_Babu_Samineni]

I don't have license. For this what are you expectingg

[marjan_it]

This is what show and what I need.

I use rank for 1 to 10 in text object but in 2 and 3 its not show.

[Anil_Babu_Samineni]

Might be this

RowNo(total) - rangesum(above(total if(num(rank(total Number,1))=above(num(rank(total Number,1))),1,0),

0,RowNo(total)))

[marjan_it]

hmm, not actually.

I want to Show order of rank name in  text object not in chart.

for example I want to show the 2nd number name in thext object. means show B or C.

When I use this  [  Aggr(if(   rank(sum(Number))=2  ,Name),Code) ]    in text onject is show -.

[marcus_sommer]

Maybe this is helpful: Continuous Ranking (no missing Rank)

- Marcus

[marjan_it · Accepted solution]

I found It, the correct answer is that use :

=Aggr(if(  rank(sum(Number),4,0)=2  ,Name),Code)

[sunny_talwar]

Just to add another set of possibility...

=FirstSortedValue(Name, -Aggr(Sum(Number)*100000 - Ord(Name), Code))

=FirstSortedValue(Name, -Aggr(Sum(Number)*100000 - Ord(Name), Code), 2)

=FirstSortedValue(Name, -Aggr(Sum(Number)*100000 - Ord(Name), Code), 3)

=FirstSortedValue(Name, -Aggr(Sum(Number)*100000 - Ord(Name), Code), 4)

=FirstSortedValue(Name, -Aggr(Sum(Number)*100000 - Ord(Name), Code), 5)

=FirstSortedValue(Name, -Aggr(Sum(Number)*100000 - Ord(Name), Code), 6)