How to create a top five.
I've working on a dataset for a while now that essencially logs the everyday orders we receive from our clients.
One of the colums records the name of the customer and I've been trying to create a report that counts how many orders a customer has requested and sort them dynamicaly as a top five/ten. It's quite easy to do on other tools like Excel through pivot tables, but sadly that functionality is locked in SmartSheet as a premium feature that would be simply hell to try and convince the company to pay the licencing fee for.
I was wondering if someone here knows of a workaround or a function that allows to do such a basic filter for the data.