Yogendra Bharti
New Member
Hi,
I have transaction/date wise data of few no of agents who are involved in Depositing & Withdrawing the money of customers. Now I want to calculate the Active no. of customers per agent, per month.
Here Active customer is defined as "The Customer who has done a minimun one transaction (dep/withdrawal) atleast once in last three months.
The Data is needed Agent ID wise on monthly basis.
Attached is the Data file along with the expected result.
Pls help.
Thanks in Advance.
I have transaction/date wise data of few no of agents who are involved in Depositing & Withdrawing the money of customers. Now I want to calculate the Active no. of customers per agent, per month.
Here Active customer is defined as "The Customer who has done a minimun one transaction (dep/withdrawal) atleast once in last three months.
The Data is needed Agent ID wise on monthly basis.
Attached is the Data file along with the expected result.
Pls help.
Thanks in Advance.