Top, Next and Rest computation

[Anonymous]

Hi All,

I have a requirement where when we select particular "Company"  and "Speciality", we need to compute "Top 33 % of the doctor belonging to multiple company of that speciality". Similarily, we will compute "Next 33% of the doctor belonging to multiple of the company" and "Rest 33% of the doctor belonging to multiple of the company".

Best regards,

Kaveri

[Anonymous]

Hi

You can use Guage chart for this ..

or

some formula like below in PIEchart ...

=if(Aggr(Rank(count(doctor)), Company,Speciality)<=3, 'Top 3 ', 'Others')

[boopeshj]

Hi Kaveri

Can you please add more details to help you

-Boo