Top 100 records

[tulasi]

Hi Everyone,

I want to get the top 100 records, this is my requirement but my report contains 393874 rows and 32 columns. Table doesn't have unique col so how can I get 100 records and I can I apply filter. When I'm trying drag row_no it was displaying but I couldn't apply filter to this(to get 100 records). Rank, running-count also I tried but when I was apply these things I'm getting extra records because of duplicates. I don't want to delete any duplicates I want to display all the records as per my count.

Can anyone give solution, please?
 

[bdbits]

How do you want to select the records? In other words, which 100 records? Just "the randomly first 100 records"?

Is this a dimensional or relational?