Forum Discussion

Razwan's avatar
Razwan
Icon for Helper I rankHelper I
5 years ago

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...
rohanjha1988's avatar
rohanjha1988
Icon for Helper II rankHelper II
5 years ago

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"). 

Razwan's avatar
Razwan
Icon for Helper I rankHelper I
5 years ago

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.