Rudi
New member
- Joined
- Jan 18, 2014
- Messages
- 134
- Reaction score
- 0
- Points
- 0
- Location
- Cape Town, RSA
- Website
- www.eileenslounge.com
- Excel Version(s)
- Excel 365 ProPlus
Hi,
I have connected Power Pivot to two tables (in the data model).
Table 1 = Suppliers with Supplier ID as primary key
Table 2 = Products with Supplier ID as foreign key
I connect the tables in Power Pivot on the key fields.
In The pivot table, I add the Supplier Key and Supplier name to the Rows Area
Then I add the Product Name from the Products Table to the Area field
What I get is ALL products showing for ALL suppliers. (I was expecting to see all suppliers with only the products they sell - due to the link)
Is this supposed to happen?
How can I only see relevant products per supplier in the pivot?
TX
Attached is the sample workbook.
View attachment 3415
I have connected Power Pivot to two tables (in the data model).
Table 1 = Suppliers with Supplier ID as primary key
Table 2 = Products with Supplier ID as foreign key
I connect the tables in Power Pivot on the key fields.
In The pivot table, I add the Supplier Key and Supplier name to the Rows Area
Then I add the Product Name from the Products Table to the Area field
What I get is ALL products showing for ALL suppliers. (I was expecting to see all suppliers with only the products they sell - due to the link)
Is this supposed to happen?
How can I only see relevant products per supplier in the pivot?
TX
Attached is the sample workbook.
View attachment 3415