Forum Discussion
Gopinath_iyer
Helper II
Helper IITop 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 shoul...
Mahesh0016
Super User
Super User
Gopinath_iyerThis 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