Your embedded dataset in SAP Analytics Cloud has columns for Country, Region, City, andCustomer Name.

To aggregate measures for columns such as Country, Region, City, and Customer Name as a single column in an embedded dataset, creating a level-based hierarchy is the most effective approach. This type of hierarchy allows you to define a multi-level structure that represents the logical relationship between different geographical entities and customer names. By doing so, you can easily perform aggregations and analyze data at various levels of detail, from the broadest level (e.g., Country) down to the most specific one (e.g., Customer Name).

References:

SAP Analytics Cloud Help Documentation: Creating Hierarchies in Models

SAP Analytics Cloud User Guide: Data Modeling and Hierarchies