Top N issue (not the unique value issue)

[KMZ_ESS]

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! 🙂

[johnt75 · Accepted solution]

Try moving that filter from the annual potential column to the account number or name column.

[johnt75 · Accepted solution]

Try moving that filter from the annual potential column to the account number or name column.

[KMZ_ESS]

That's better, but still strange. Now I have 17 unique values (and 22 entries in total, which is less of an issue, though).

[johnt75 · Accepted solution]

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.

[KMZ_ESS]

You're spot on! 🙂