![]() ![]() With either of your pivot tables created, you should see both tables in the PivotTable Fields window from the All view. ![]() Repeat these steps for the Customers table. Check the Add this data to the Data Model box.Go to the Insert tab in the ribbon and select Pivot Table from the Tables section. One solution would be to add two more columns to the 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 you do if you want to analyze the Orders data by customer Name or Country? This example has an Orders table that contains data related to customer orders such as the Customer ID, Product Sold, and the Total.Īnother table called Customers has the Name and Country for each Customer ID.
0 Comments
Leave a Reply. |