I have two datasets. One dataset is a list of customers and details about what kind of customer they are and where they are based geographically. The other is customer sales history. I want to create a relationship between these two worksheets so I can use the order history data to create different pivot tables from the customer details and then to drill down into the pivot tables to get a list of customers to contact.
In this scenario I want to know the below:
Which customers have never purchased anything?
Which customers have purchased English-only?
Which customers have purchased English and Maths?
Because customers appear more than once in the order history worksheet I can't create a relationship from Customer details to Order History, only the other way round.
Bookmarks