Customer Counts for various conditions

[fazunus]

Dear Community Members,

I am working on customer count expressions for various conditions based on their contact activity in current period.Need help in some of the expressions to exclude some customers based on activity in the past.

For Ex. New Enquires ,the customer with "ENQ" codes are considered new for selected period but to exclude those who have any enquiry in last three months.

The details are in the attached sheet.

[avinashelite]

Could you please share the sample data set and the required output ...that will help us to frame the expressions 

[fazunus]

Thanks for quick response.

I have attached the sample data files.

Regards,

[fazunus]

Output Required is also attached.

[fazunus]

Hi,

@avinashelite

Will you be able to help frame the expressions based on data provided.

Thanks for the support.

Regards,

Fazal