Hi All,
I have a Performance Template of the advisors and have updated Percentile/Percent Rank Formula for the respective Metrics to calculate Quintile Performance for respective Advisors accordingly.
Also, I have created columns separately to calculate Quintile based on Overall Performance on Weekly basis, Quintile based on FLM Wise Performance on Weekly basis, Quintile based on Span Wise Performance on Weekly basis, Quintile based on Queue Wise Performance on Weekly basis, Quintile based on Tenurity Wise Performance on Weekly basis.
Is there any way that we can use Percentile/Percent Rank Formula for the respective Metrics to calculate Quintile Performance for respective Advisors accordingly in Pivot?
Attached my working file.
I would appreciate your help on this please!!
Thanks in Advance!!
Happy New Year 2016!!
I await for your response on this!!
Regards,
Yadavagiri
Bookmarks