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