Summarize

[vuducult]

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.

[Ender]

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.

[vuducult]

Thank you very much - that did the trick!