Set Analysis On previous 4 month

[jood_ahmad]

Dears,

Can any one help me on this;

I need to get the new Customers & Old Customers from the customers table, the old customers that he inactive since 4 month and the new customer is active in the 4 month, i try to tack the max date -4 to get the count for customer(old) but did not work.

or how can i count the frequency for customer id in Max  Month -4 (last 4 month)

Regards.

Message was edited by: Ahmad Kastero

[lironbaram]

hi

if you can use set analysis

with this expression for the dates

sum({<date={"$(=addmonths(max(date),-4))"}>})

[maxgro]

=count({$ <date={"<=$(=Addmonths(max(d),-4))"}>} customer)  

[jood_ahmad]

Thank you But still not work

[jonas_rezende]

Hi, ahmadkastero‌.

See if expression work like desired.

Count({1<%Date = {">=$(=MakeDate(Year(Max({1}%Date)-120),Month(Max({1}%Date)-120)))"} >} Customer)

The identifier can be modified of agree with your choice, example: $, 0,$1.

Hope this helps!