I own a food business and every order is entered into Zoho with:
- a unique Customer ID
- total order amount
- date of order
With this information, I want to be able to see a list of my "best" customers.
In other words, descending lists arranged according to:
- Frequency of orders
- Total number orders in a year
- Total amount spent in a year
Currently, I know how to create a report and "group" together the orders of each customer.
It is now possible to manually calculate who my best customers are.
HOWEVER, the difficult part is being able to automatically arrange and display the best customers according to the parameters stated above.
Can this be done with Zoho Creator? I'm very excited to see the results. This would be a game-changer if possible for my small business. A lot of thanks in advance for anyone who could help me.