Hi,
The division of customers into different classes only works for one case. Only the customers from Europe. For the customers in America and Asia there is exactly only one class. Each customer is classified as a C customer.
I have not changed the code. Only the sales organization has been changed. If I remove this filter and look at it on a global level, the division works into different classes but not within the intended limits (B starts at 90%).
The abc function is configured as following:
CASE
WHEN ABC(SUM(VBAP.NETWR_CONVERTED), 0.6, 0.20) = 1 THEN A
WHEN ABC(SUM(VBAP.NETWR_CONVERTED), 0.6, 0.20) = 2 THEN B
ELSE C
END