rank() question

[#1]

i have table like this. 

i used rank(score) to get top 10,  but when the score are the same, i want to sort by <# of surveys> by dec,  i do not know how to achieve it

for example:

Derick /Herica /Agnes all got 4.92, but i want to sort their rank by # of surveys

Rank	Center	Teacher Name	score	# of surveys
1	J	jack	4.95	15
2	S	Derick	4.92	20
3	C	Herica	4.92	17
4	J	Agnes	4.92	26
5	S	Roneill	4.91	19
6	J	Lydia	4.90	21
7	S	Simone	4.87	20
8-9	C	Brian	4.85	15
8-9	JH	James	4.85	15
10	S	Esme	4.84	16

[#2]

Hi,

I think, in SORT tab (of the properties of your chart), you can first sort it by rank and then by score.

Regards,

http://quickdevtips.blogspot.com/

[christophebrault]

Hi,

If you want that your rank column be true, try this :

=rank(sum(score)+sum(# of surveys)/10000)

Turn surveys to decimal and add to score in the rank function.

[#4]

above both not working

center name and teacher name is dimenion and scores and # of seuveys is expression in straight table

[#5]

above both not working

center name and teacher name is dimenion and scores and # of seuveys is expression in straight table

[#6]

above both not working

center name and teacher name is dimenion and scores and # of seuveys is expression in straight table

above both not working

center name and teacher name is dimenion and scores and # of seuveys is expression in straight table

[Anonymous]

hi maxshen

                   Try the following

                   Go to sort tab

                   for Rank field - check d box numeric feild- ascending

then

                   for # surveys  field - check d box numeric filed -descending

you can simply take table box n do the above.

please try n let me knw.

reagards,

vaibhav.