What is the logic for item being key item
is it simply what you have underlined? or there is any solid computations such as item being either highest performing or lowest performing under each entity type?
1. If logic is simply as you have marked. I would suggested create a calculated field
Country + Brand + Entity and create a group based on this calculated field with all key item combinations marked as key and rest as others.
2. based on value
see which one of these suits your requirement
Thanks for quick response!
Yes the underlined brands are Key but I also want to categorize the rest as others.
Also a brand could be key in one country but not key in another.
Appreciate the help
1 of 1 people found this helpful
I think you just need a series of IF statements in a calculated field..
IF [Country] = "China" and [Brand] = "Brand AB" then "Key"
ELSEIF [Country] = "China" and [Brand] = "BRAND AA" then "Key"