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.

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.