June 14, 200421 yr Newbies I have this db with CustName and different products sold to them. Most customers are repeat customers and have records for each of their purchases. Weekly and monthly I need to summarize this to show how many individual customers have made a purchase (not how many items purchased just numbers of invoices or POs). I don't want to show the specific CustName just a total of unique customers' invoices (eg. May I had 23 customers that made up 144 orders; April I had 17 customers that made up 201 orders). I've been using FM for many years, and it annoys me that I can't figure this out. Am I missing something obvious here? Thanks for your time.
June 14, 200421 yr This may work: Customer ID (number) Invoice ID (number) Count of Invoice ID (summary) = Count of Invoice ID SubFrequency (calculation, number result) = 1/GetSummary(Count of Invoice ID, Customer ID) Total by Customer ID (summary) = Total of SubFrequency The Total by Customer ID should give the number of unique customers in the found set.
Create an account or sign in to comment