I have a table of customers which I would like to segment into 4 groups, and I was hoping one of the experts here might be able to help!
As an example, my summarized table (grouped by customers, sum of quantity and margins) looks like this:
My end result is to group each customer into 1 of 4 buckets:
- High Volume, High Margin
- High Volume, Low Margin
- Low Volume, High Margin
- Low Volume, Low Margin
Question: How can I create two quartile calculations, which segment each of the "Quantity" and "Gross Margin" fields into quartiles, so that I can compare the combination of results and bucket the customers into the 4 groups mentioned above?
Alternatively, is there any other way of achieving this without quartiles?
Any insights are greatly appreciated!