Limit # of records in a table report
I'd like to be able to run a report that shows just the top 20 results. For instance, customers - sorted by volume from largest to smallest, only returning the top 20. I can't seem to figure out how ...
Forum Discussion
I think it will give you more reliable results, but not sure - you'll need to test. I do expect that you will have multiple records with the same rank if there are volumes that are the same.
If that's the case, you'll need to find something else that is unique that you can include in your filter/query.
That's the thing that's frustrating - none of my records have the same volume, but it's still ranking many of them as 1, etc. (see the photo above) It doesn't seem to work and I can't figure out why. It's basically useless - I can sort the report by the column I'm actually interested in, I just only want to see the top 15 or 20, not all 2000 records.
------------------------------
Thanks,
Chris Newsome
------------------------------