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?
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?