on 03-10-2009 1:41 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.