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...
Anonymous
Sorry, I don't want it to be changed in a visual or filter pane.
In the end I would like to have that segmentation (Big, Medium, Small) in a matrix. Then, if you will expand a group it will show their corresponding customers ranked by their revenue.
The struggle is the calculation itself in a calculated column of:
First 20% of customers = Big customers
Next 30% of customers= Medium customers
Last 50% of customers = Small customers