One solution would be to add two more columns to our Orders data and use a VLOOKUP function to bring in the customer Name and Country based on the Customer ID.Īnother more elegant solution would be to use the pivot table Data Model to create a Relationship between the Orders table and the Customers table using the Customer ID field in both tables.Ĭreate a table based on the Orders table. But what do we do if we want to analyze our Orders data by customer Name or Country? In another table called Customers we have the Name and Country for each Customer ID.
In our example we have an Orders table that contains data related to customer orders such as the Customer ID, Product Sold, and the Total.
0 kommentar(er)
