Return top 5 entries in a report

SimonT

Hi

I am trying to set a report to only return the top 5 entries in a sheet based on a sort criteria,  Does anyone know how this can be achieved?

Thanks in advance

Paul Newcome

You would need to set up a table and reference your data using a LARGE function.

Mike Wilday

Here is some additional data on using the Large function.

https://help.smartsheet.com/function/large

SimonT

Thanks for your help Paul

SimonT

Hi Mike

Answered my next question before I had even asked it, perfect! Thanks

 

Mike Wilday

You're welcome! Let us know if you have any other questions. 

SimonT

Ok so now I have the top 5 values for one column..... but can I return multiple columns from that row?  For example the names, values and country of the top 5 customers by order value.

Paul Newcome

Thanks for the cover, Mike. I had copied the same link to add to my comment, got busy before I hit submit, then forgot to put the link in when I came back to it. It's been a "fun" week.

Paul Newcome

There are a few different options. The easiest one would be to build the LARGE function into an IF statement in a checkbox column that will automatically check the box if that person is in the top 5. You can then create a report that pulls the rows based on having that box checked.

Mike Wilday

Haha. I understand those types of week. I think I've had one of those years.