I need to find number of repeated customers who made transaction more than once in a given period.
scenario 1:
if i select the month it should show the number of customers who made transaction more than once in the selected month.(which should not consider the customer entry as 2 if he had made transaction in the previous month, it should count the entry as 1 if particular customer repeats from previous month to selected month)
scenario 2:
if i select the quarter it should show the number of customers who made transaction more than once in the selected quarter.
scenario 3:
if i select the year it should show the number of customers who made transaction more than once in the selected year.
Note: i have period filter which will pass the date range accordingly based on the selection(month,quarter,year)
i am using fields: Customer code, Doc_date
Please help in this regard,