Top N calculation

[Gopinath_iyer]

Hi

I have a column with Manager names repeating and i want to show the top 5 managers based on their count .

I tried to use the Top N in filters but it is not giving proper result.

how should i achieve this?

Regards,

Gopi

[Mahesh0016]

@Gopinath_iyer  I hope this  helps you!Thank You!!

[Gopinath_iyer]

This is not giving the correct result. 

for e.g from column below i want only Top 5 manager based on count but Top N filter is showing 6 names. 

Manager

Rishabh gupta

Rishabh gupta

Rishabh gupta

Ajit Kumar Verma

Ajit Kumar Verma

Suzanne Camelio

Michael Clements, Rashmi Laroia

Vaibhav Srivastava

Pronay Chakraborty, Akshat Khanijo

Jordon Walker, Mr. Scott

Nishant Agarwal

Nishant Agarwal

Suzanne Camelio

Rishabh gupta

Vaibhav Srivastava

James Polis

Jordon Walker, Mr. Scott

Jordon Walker, Mr. Scott

Jordon Walker, Mr. Scott

Suzanne Camelio

[Mahesh0016]

@gopinath_iye because Of two of manager same count that's why is show 6 Name.

[Gopinath_iyer]

yes, but user wants to see only top 5 names