amount of new sales per customer

[isanbaeva]

Hi, everybody!

I have an issue - I want to count only new sales per customer monthly. I tried to use function Firstsortedvalue, but it seems doesnt work correctly. 

 I have:

customers, date of sale, product.

How I may solve it not in boot script?

Thank you, 

Elena Isanbaeva.

[Susan_DS]

Hi, Elena,

Perhaps something like this: 

Count(product*if(date of sale = aggr(nodistinct max(date of sale),customers),1,0)

[MarcoWedel]

How do you calculate the count of new sales per customer monthly?
Please post some sample data and your expected result.
thanks