2 Item ABC

[Mack1int]

Good Morning All,

 I have an ABC analysis in a static normalised table that I created but I am now have issue where when I have just 2 items for a location,brand. The problem is that the segmentation does not give the results I need; either A/C or B/C because of the way the formual works when with cumulative percentage. I just need help writing a clause that says when there are 2 items for Location /Brand it just needs to be "A" and "B" based on the sales revenue and not on the cumulative percentage. Any help would be much appreciated.

This is the current calculated column I am using for the ABC segmentation.

ABC Product =
SWITCH (
TRUE,
ABC[Cumulated Percentage] <= 0.8, "A",
ABC[Cumulated Percentage] <= 0.95, "B",
"C"
)

[afzalphatan · Accepted solution]

Hope formula in the pic does ur job...Kudos

[Mack1int]

Amazing @afzalphatan!! I hope you have a great weekend.

[v-yulgu-msft]

Hi @Mack1int,

To better illustrate your scenario, please share some sample data and show us your desired output.

Regards,

Yuliana Gu

[Mack1int]

@v-yulgu-msft Thank you for your reply, I hope this image helps.