Hi All,
Firstly, Happy New Year 2016 to Every One!!
I would like to understand, if we can add Percent Rank formula to calculate Quintile based performance of an advisor in Pivot Calculated Field.
I have enclosed my working file, where I have calculated Quintile for the respective metrics as Quintile Based Performance - Overall Site Performance, Quintile Based Performance - TL Wise Performance, Quintile Based Performance - Span Wise Performance, Quintile Based Performance - Queue Wise Performance, Quintile Based Performance - Tenurity Wise Performance. Formulas you can find in the attached document.
Can we calculate/use these formula in Pivot Calculate field ? Please let me know if this is possible.
I would appreciate if anyone could help on this please.
Regards,
Yadavagiri
Bookmarks