how to create a table that has 20 rows with ranking

[Newone8]

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.

[Lohit]

Hi,

Go to custom query and at the end, add "limit 20". It should limit the table in the report to just 20 rows Below is the example with limit as 5

Regards,

Lohit

[Newone8]

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. 

[Lohit]

Hi,

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.

Regards,,

Lohit