0

Filter customers with x orders in period

Jet Reports Historic Posts

July 19, 2017 06:38

None

Follow

hi,

I am looking for a formula wich filter customers who had placed a specific number of orders for a specific item in a specific period.

For example:
Who has ordered Item A at least 3 times in the period 2017

Anybody got an idea?

Thanks.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts July 19, 2017 15:01

  Hello -
  
  Sorting and/or filtering by count or sum is a pretty common thread here on this forum.
  
  Here is the basic concept.
  
  I've built a rudimentary report that shows my customers and some information about all of the their orders in the year 2017:
  
  
  
  
  the design looks like this:
  
  
  
  The NL("Count") function is the same as the 2nd NL("Rows") function - just using the word "count", instead.
  
  
  Let's suppose that I only want to see those customer who have EXACTLY three orders during the year.
  
  I would take that NL(Count) function (with minor changes) and embed it within my original NL(Rows) function:
  
  
  
  
  Now, when I run my report, I only get customers who have exactly three transactions in my Cust. Ledger Entry table for the year 2017:
  
  
  
  
  I hope that gets you pointed in the right direction.
• 0
  
  Jet Reports Historic Posts July 20, 2017 12:55

  Yep, that does the trick…..
  
  Thanks a lot!!!!