Counting Multiple Countries Per Region
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 A||United States||AM||No|
|Customer A||United Kingdom||EU||Yes|
|Customer B||United States||AM||No|
Any advice on how to build this module?