Hi,
I am working on Health care project and facing problem while arriving
percentile percentage.
Functionality details:
List boxes: 1.Year 2.Month 3.Day 4.Clinics 5.designation 6.Staff Name 7.
Age range
Dimensions: 1. Dynamic dimension for (clinic,designation and staff) 2. Age
range
Straight table columns: 1. Dynamic dimension 2. Age range
1. Consultations 2. No of hours 3.
consultation per hour ( 1st column / 2nd column) 4. Max of [consultation
per hour] 5. Percentile
My requirement:
How to arrive 4th column (max of consultation per hour) based on selection
criteria.
Example:
1. when select clinic the Max of consultation per hour (4th column) should
display irrespective of clinic i.e. top one performance of all clinics.
2. when select Designation as doctor the 4th column percentage should
display top one performer of all doctors
3. when select Age range the 4th column percentage should display top one
performance of the selected range.
I am struggling with it last couple of weeks so i request you to provide
solution.
Kind Regards
Hanumantha Rao K
Project Leader
*Sathguru Management Consultants *
Plot 54, Sagar Society, Road No 2, Banjara Hills, Hyderabad – 500034, India
Phone: + 91 40 3106 0260, 3016 0333 *| Mobile: *+91 9885169231 | Fax: +91
40 4004 0554
552 Massachusetts Avenue, Suite 204, Cambridge, MA 02139
Phone: + 1 734 389 5911 (US)* | *Fax: +1 617 812 0263
www.sathguru.com
