I have a module that needs to tell me whether a customer is present in more than one country in each region. For example, Customer A is only present in United States under AM region. This means that it is not an inter-region customer in AM. But in EU region, it is present in United Kingdom and Italy, so it is an Inter-Region customer in EU. Please see table below for visual reference. I can't figure out a formula for the Inter-Region column to get this requirement.
Customer | Country | Region | | Inter-Region? |
Customer A | United States | AM | | No |
Customer A | United Kingdom | EU | | Yes |
Customer A | Italy | EU | | Yes |
Customer A | Singapore | AP | | No |
Customer B | Singapore | AP | | No |
Customer B | France | EU | | No |
Customer B | United States | AM | | No |
Customer C | Germany | EU | | Yes |
Customer C | France | EU | | Yes |
Any advice on how to build this module?