Forum Discussion

JohnRomano's avatar
JohnRomano
Qrew Cadet
2 months ago

Select a specific number of records within a report or table.

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 th...
reports
DonLarson's avatar
DonLarson
Qrew Elite
2 months ago

John,

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.   QuickBaseJunkie has video on this

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.