Hi guys,
maybe you could help me with this.
I have an automatically updated Google Sheets table with all the information about my customers. Basically the columns are:
A - Unique order ID
B - Date of the order
C - Date of the payment
E - Name of the customer
F - Business ID of the customer
H - Total price of the order
I would like to line up the customers (to another sheet maybe) based on:
a) the number of their orders
b) the total turnover
So ideally i would clearly see who paid me the most money and who made the most orders and I could put that in a chart.
I was able to list all the customers in a certain date range (thanks to the query function). But I am having a hard time figuring out how to achieve this.
Any help would be appreciated.
Thank you.
Bookmarks