Hi,
Just started with power pivot and did some courses, thought I understood it until I had to work with real data which clearly needs to be set up correctly.
My struggle, I have one data query (Perrigo) which has an unique product ID, this is the one I can link to my two others queries (Product availability & Content overall) which have sales data on product level but also include the retailers. However I don't have the retailer list in my nr 1 query, so now when I want to add the retailer data to my rows or columns in the pivot table it says it it missing the connection.
It seems like I can only use data for rows and columns from the Perrigo query list and not from the (Product availability & Content overall query. I thought when making a connection between these three with the product ID I was able to mix the data together.
Do I need to adjust my data query or am I understanding the power pivot working not correctly?
Just started with power pivot and did some courses, thought I understood it until I had to work with real data which clearly needs to be set up correctly.
My struggle, I have one data query (Perrigo) which has an unique product ID, this is the one I can link to my two others queries (Product availability & Content overall) which have sales data on product level but also include the retailers. However I don't have the retailer list in my nr 1 query, so now when I want to add the retailer data to my rows or columns in the pivot table it says it it missing the connection.
It seems like I can only use data for rows and columns from the Perrigo query list and not from the (Product availability & Content overall query. I thought when making a connection between these three with the product ID I was able to mix the data together.
Do I need to adjust my data query or am I understanding the power pivot working not correctly?
