ABC Curve

[William_Moreno]

Hi everyone, 

I have the spread sheet below to calculate the ABC curve, the calculation should show analyse per month and local. Could you help me?

Date	Local	Product	Qty
01/01/2023	San Diego	A1	15
01/01/2023	San Diego	A2	30
01/01/2023	San Diego	A3	55
01/01/2023	San Diego	A4	20
01/01/2023	San Diego	A5	5
01/01/2023	San Diego	A4	20
01/01/2023	San Diego	A5	5
01/01/2023	San Diego	A4	20
01/01/2023	San Diego	A5	5
01/01/2023	Los Angeles	A1	15
01/01/2023	Los Angeles	A2	30
01/01/2023	Los Angeles	A3	55
01/01/2023	Los Angeles	A4	20
01/01/2023	Los Angeles	A5	5

Result expected

Local	Product	Qty	%	%Acumulado	Curva
San Diego	A4	60	34%	34%	A
San Diego	A3	55	31%	66%	A
San Diego	A2	30	17%	83%	A
San Diego	A5	15	9%	91%	B
San Diego	A1	15	9%	100%	C
		175
Local	Product	Qty	%	%Acumulado	Curva
Los Angeles	A3	55	44%	44%	A
Los Angeles	A2	30	24%	68%	A
Los Angeles	A4	20	16%	84%	A
Los Angeles	A1	15	12%	96%	C
Los Angeles	A5	5	4%	100%	C
		125

[William_Moreno]

Hi @Daniel29195 thanks a lot for answer me! If  it is possible, Could you develop this solution in calculate column, not as measure,. I need a static calculation, it means abc analysis has to consider (date and local) and don't change with slices. I'll be thankfull if could help me in this problem.

[lbendlin]

Please indicate how that would look like based on your provided sample data.  How are you breaking the ties?

[Daniel29195 · Accepted solution]

Hello @William_Moreno 

output : 

kindly download the solution from here :

https://drive.google.com/file/d/1gp5pn_u3FiURHznIyN4ln-uXHBRT8kkc/view?usp=sharing

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅!
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠