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
First, can you change the operator from GT to GTE.
Will that correct it? I did that based on what she said in the video.
------------------------------
Thanks,
Chris Newsome
------------------------------
- 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
------------------------------- It's not making sense to me either. Silly question, what is the field type for Volume?
the volume field is "Total Won Value (YTD)" and is a Currency (Summary) field, as the info is coming in from another table.
------------------------------
Thanks,
Chris Newsome
------------------------------