First purchase et Second purchase

[Anonymous]

Hello

I have a file containing dates, families of products and customers. I would know about each family the number of customers who ordered a first (minimum date)

I have done this and  it's work

sum( {<[ID Customer] = {"=min(Date)"} >}  Nb_customer)

and the number of customers who ordered a second time by super family.

sum( {<[ID Customer] = {"=min(Date), [Big Family]={'FORME & BEAUTE'}" } >} Nb_Customer)

the goal is to reach this but with  my second calculation everything is at zero

Big Family	sum(Turnover)	First purchase	Second purchase MAISON ET ENTRETIEN	Second purchase BRICOLAGE	Second purchase CUISINE	Second purchase FORME & BEAUTE
MAISON ET ENTRETIEN	646,79245	9	0	0	0	0
BRICOLAGE	689,14223	16	0	3	0	0
CUISINE	3707,0812	33	0	0	6	0
FORME & BEAUTE	11957,26189	148	0	0	0	30

thanks for your help

[Anil_Babu_Samineni]

For me, Quiet syntax wrong. Try this?

sum( {<[ID Customer] = {$(=min(Date))}, [Big Family]={'FORME & BEAUTE'} >} Nb_Customer)

Or

sum( {<Date = {$(=min(Date))}, [Big Family]={'FORME & BEAUTE'} >} Nb_Customer)

[tresesco]

Your first expression itself seems to be wrong. When you write -  sum( {<[ID Customer] = {"=min(Date)"} >}  Nb_customer) that means you are comparing customer ID with a date value, which is potentially wrong. Correct way of writing similar set expression would be something like:  sum( {<Date = {'$(Date(min(Date))'} >}  Nb_customer)

If you could share a sample app to work on, we could help you better.

[Anonymous]

Hello

You're right, this is what i would like in reality 

thanks a lot

[Anonymous]

Sorry,

I was wrong about my calculations, i published a correction

thanks

[tresesco]

Like this?

Count( {<Date = {'$(=Date(min(Date)))'}>} Occurrence_Client)

Count( {<Date = {'$(=Date(min(Date,2)))'}>} Occurrence_Client)

Count( {<Date = {'$(=Date(min(Date,3)))'}>} Occurrence_Client)

PFA as well.

---

[Anonymous]

thanks

it works well on a client

but over a period it does not work.

I have too few results because i have 191 customers

thanks for your help