I would like to count the customers who have purchased over $x.xx amount from a certain vendor.
For instance 55 customers purchased over $1k from Vendor Y.
40 customers purchased over $2k from Vendor Y.
20 customers purchased over $3k from Vendor Y.
Etc.
Any ideas on how I could do that?
Thank you!
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi -
While there would be a few questions to ask before a definitive solution could be determined, here is something that might get you pointed in the right direction.
I created a simple report that calculates customer sales grouped by salesperson. It then counts the number of customers (for each salesperson) who have total sales greater than 200,000.
It does this using two methods: (1) brute force [with separate functions to list the customers, add up their sales, then count the number that are greater than 200K] and (2) a single Jet Essentials function to accomplish the same thing.
While the technique is not trivial, it is similar to when one wants to sort by the sum of a field.
I hope this helps.
Please sign in to leave a comment.