Hey Everyone,

I need to do a **Daily customer analysis** (ABC clustering) that is bound to the following parameters.

The parameters are measured against the limits of every customer’s average sales over a year.

Group | Sort | Low | High |
---|---|---|---|

A+ | 1 | 3.286 | 999999 |

A | 2 | 978 | 3.285 |

B | 3 | 497 | 977 |

C | 4 | 250 | 496 |

C- | 5 | 0 | 249 |

In the analysis, sales are then to take place in the total cluster. For Example, how much sales did all the customers in the A+ category make in total? Like this:

Group | Total Sales | % Share | Total Sales LY | % Share LY |
---|---|---|---|---|

A+ | 1.742.861 | 67,80% | 1.767.399 | 66,80% |

A | 496.128 | 19,30% | 515.130 | 20,30% |

B | 222.209 | 8,60% | 226.146 | 6,60% |

C | 86.408 | 3,40% | 83.360 | 5,40% |

C- | 23.048 | 0,90% | 15.921 | 0,90% |

Here’s my data model. I have a sales table and a customer table.

Do you have a solution here?

I’ve tried a lot of your segmentation videos here but I don’t get it displayed correctly.