I have a table of books I read. Each completed book has a float rating between 0 - 5. I have a summary table that is sorted by “my rating” column.
How do I limit this table to only the first 10 results?
Hi @Vinnland ,
You can add a formula column that ranks the books based on their rating. I used the Assistant to generate the formula.
Then, filter this helper column to only show those ranked from 1-10 by setting a max value of 10.
You can hide the Rank column from view so this all works in the background.
Thanks,
Natalie
2 Likes
Thats great. Grist is great. Thanks @natalie-grist
1 Like