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 shoul...
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.
yes, but user wants to see only top 5 names