Forum Discussion

Mack1int's avatar
Mack1int
Frequent Visitor
8 years ago
Solved

2 Item ABC

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"
)

4 Replies