Forum Discussion

KMZ_ESS's avatar
KMZ_ESS
Helper I
3 years ago
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...
  • johnt75's avatar
    3 years ago

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

  • johnt75's avatar
    johnt75
    3 years ago

    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.