Based on a Customer List and number of products purchased by them month on month, I need to categorize the customers into the following categories.
Active – Customers who have been purchasing products month on month basis CONTINUOUSLY
Inactive – customers who have not purchased any item for the chosen year, month range
Returning – Customer Purchased a product initially and thereafter no activity (say 3 months gap max between purchases)
New – No Purchase by the customer yet. Customer just created or yet to start any transaction.
Dimensions used:
CustomerName
Year
Month
Expression:
Sum(Quantity)
Note: he above categories should be set based on year and month selection. The user has the option of choosing any year and month and see the customer status
