how to create a table that has 20 rows with ranking
I need to use ranking for a measurement (ex. Top 20). But I want to create table with only 20 rows regardless how many values ranking returns. I cannot find where I can place a limitation.
Thanks for sharing the query.
But would that return the top x rows? For instance, I have measurement 100, 98, 90, 90, 90. If I do a top 3, then it will give me five rows in the table. How can I display three rows in the table in stead of five rows? I do not want the table expand automatically.
If you right-click on the report column and use Ranking to rank the values, then for 100, 98, 90, 90, 90, it will show all the 5 rows.
But if you put a limit in the query itself, lets say 3, it will restrict the number of rows to just 3 irrespective of repeating values.