How to filter top 10 rows based on column.

[Anonymous]

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

[lbendlin · Accepted solution]

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.