Forum Discussion
Top N calculation
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
4 Replies
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 gopinath_iye because Of two of manager same count that's why is show 6 Name.
