Identifying the new customers in every month

[#1]

H Guys

I have a table which has following fields:

Order Date , Customer Name , Order Sale

I want to identify , how many new customer joined every month \

and How many Customers from Jan are in Feb , Mar .......Dec ,

How many Customers From Feb are in Mar ,Apr.........Dec

.

.

.

.

How many Customers From Nov are in  Dec

[afurtado]

Hi.  you can see an example in QV manual,  You can in your script put 0 or 1 when a client is new. And to know clients from one month buy in another, you can use set analysis with examples below (change product for months) and using 0 or 1 to identify new clients.

SET ANALYSIS

Examples:

sum( {$<Customer = P({1<Product={‘Shoe’}>} Customer)>} Sales )
returns the sales for current selection, but only those customers that ever have bought the product ‘Shoe’. The element function P( ) here returns a list of possible customers; those that are implied by the selection ‘Shoe’ in the field Product.

sum( {$<Customer = P({1<Product={‘Shoe’}>})>} Sales )
same as above. If the field in the element function is omitted, the function will return the possible values of the field specified in the outer assignment.

sum( {$<Customer = P({1<Product={‘Shoe’}>} Supplier)>} Sales )
returns the sales for current selection, but only those customers that ever have supplied the product ‘Shoe’. The element function P( ) here returns a list of possible suppliers; those that are implied by the selection ‘Shoe’ in the field Product. The list of suppliers is then used as a selection in the field Customer.

Alessandro Furtado