I have a report with thousands of records, I can use a filter to reduce the number of records; however, I want to select an exact number of records within a report. For example, the filter reduces the number of records 200, but I want to select the first 50 records. Is there a way to select a specific number of records within a report or a table?
Question
Select a specific number of records within a report or table.
+5
+15What do you mean select? Is there a check box in the records? If you put that field in the report, you can grid edit, check the first one and copy down the next 49.
Does that answer or is your business case different?
+15John,
Now I understand the question. That is a very useful feature in Excel, to the best of my knowledge there is no native functionality that mirrors that.
You can build a formula query in the report that ranks the records.
https://www.youtube.com/watch?v=HVaUfnuBp4s&t=780s
Instead of dollars, you will want to use the criteria from your report that filtered the records down to 200.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.