Hi Caroline, Thanks for posting your query. I suggest the following to hopefully solve your problem: Kindly double-check the hierarchy of your location names. Some locations may be towns or villages, not cities. Please try adding Supplier County and/or Country to Location category if you have them in your table. If you…