Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to filter top 10 rows based on column.

I have set of data which is having multiple rows. How can I show/filter/differntiate only top 10 rows based on Column2 (Desc order).  

Here is the sample data

 

 

Thanks

SK

 

Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    in the visuals filters dialog  click on the dropdown for Column1 and then use Advanced Filter, Top 10 by Column2

     

    Note:  you may see more than 10 rows if there are value ties.

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    in the visuals filters dialog  click on the dropdown for Column1 and then use Advanced Filter, Top 10 by Column2

     

    Note:  you may see more than 10 rows if there are value ties.