Forum Discussion
Helper ITop N issue (not the unique value issue)
Dear all,
I want to see the top20 results of a column, but I'm getting way more than 20 different values. Having the same value shown more than once is not a problem in this case. I'm actually getting more than 20 different unique values. Can somebody see an error in what I did? Thanks a lot! 🙂
Try moving that filter from the annual potential column to the account number or name column.
That sounds like it could be correct. If the top 16 values only provide, e.g., 19 rows then it would add the next value as well. If the 17th value then provided an additional 3 rows that would take it to 22.
4 Replies
johnt75Super User
Try moving that filter from the annual potential column to the account number or name column.
KMZ_ESSThat's better, but still strange. Now I have 17 unique values (and 22 entries in total, which is less of an issue, though).
- johnt75
That sounds like it could be correct. If the top 16 values only provide, e.g., 19 rows then it would add the next value as well. If the 17th value then provided an additional 3 rows that would take it to 22.