cancel
Showing results for 
Search instead for 
Did you mean: 

Help;how to put datas in order according to the NO. in query?

Former Member
0 Kudos

for example there is a infoprovider includes :

agency,month,reach rate,rank

A , 1 , 90%

B , 1 , 80%

C , 1 , 20%

Then how to show three agencys' (A B C) rate of Achievement :A is no.1 ,B is no.2 ,C is no.3

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member181964
Active Contributor
0 Kudos

Hi,

Yes you can do it.

agency ---month---reach rate--Formula(reach rate)
A ------------- 1 -------- 90%-----  1
B ------------- 1 ------- 80% ----  2
C --------------1------- 20% -----  3

In Craate Formula for Rank, then Drop Reach Rate in Rank Formula, then right click on Rank and Properties, and set Calculate Single value as = Ranked Lias, so based on teh values it will display the ranks.

Thank

Reddy

Edited by: Surendra Reddy on Mar 10, 2009 4:37 AM

Former Member
0 Kudos

Dear Reddy,

thank you very much ,your answer did help me a lot .

thank you again

susie

Mar 11,2009