Forum Discussion
Customer Segmentation By Dynamic Percentages
Hello, I am struggling to perform a correct segmentation of customers based on their [Total Revenue] as follows: First 20% of them = Big customers Next 30% of them = Medium customers Last 50% o...
After the Rank column, create another calculated column and use Switch function.
Cust_Categorization = SWITCH([Rank], 1, "Big customers", 2, "Big customers", 3, "Medium Customers", 4, "Medium Customers" , 5, "Medium Customers", "Small customers").
rohanjha1988
Thanks for your suggestion, but if in time the number of customer increases, then hardcoding will not work.
I already tried hardcoding and it's working only for current number of customers which is 10.