Forum Discussion
Solved
Top 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 ge...
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.
That's better, but still strange. Now I have 17 unique values (and 22 entries in total, which is less of an issue, though).