Counting Multiple Countries Per Region

Options
souichirobenefield
souichirobenefield Member, ALL USERS Posts: 4 New Contributor
in Extensibility

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.

 

CustomerCountryRegion Inter-Region?
Customer AUnited StatesAM No
Customer AUnited KingdomEU Yes
Customer AItalyEU Yes
Customer ASingaporeAP No
Customer BSingaporeAP No
Customer BFranceEU No
Customer BUnited StatesAM No
Customer CGermanyEU Yes
Customer CFranceEU Yes

Any advice on how to build this module?

Tagged:

Comments

  • souichirobenefield
    souichirobenefield Member, ALL USERS Posts: 4 New Contributor

    Thank you for this. But, the Customer assignment is done in a list with Countries as parents. So the module would actually look the attached file. Any workaround for this?

     

    Sample.PNG

     

    Thank you so much!

     

     

  • souichirobenefield
    souichirobenefield Member, ALL USERS Posts: 4 New Contributor

    I created Country Properties module that Applies to Country list, FORMAT: Country. So I was able to get get the Regions per Country in this module.

     

    For the Customer Spread module, I can't seem to make it work. How do I set up the Count line item in this module?

  • souichirobenefield
    souichirobenefield Member, ALL USERS Posts: 4 New Contributor

    Hi,

     

    I was referring to your first solution. I ended up using the second solution anyway so I had everything setup and working already. Thank you so much!

Categories