rad1112000
New Member
- Joined
- Aug 15, 2014
- Messages
- 2
This is my first time using table relationships in excel 2013 and while it seems straightforward I must be missing something as it is not working as intended.
As a test, I set up to small tables. Table 1 contains two columns- model # and capacity. Table 2 contains 3 columns - model #, dim 1, dim 2. The two tables are related together via the model # columns.
I set up a pivot table that I want to show model #, capacity, dim 1 & dim 2. The first two items which come from the "master" table show up correctly, but the dim 1 & dim 2 which come from the "related" table come in to my pivot table as a list of all items in dim 1 or dim2 column for each row of data from Table 1. I want only the dim 1 and dim 2 that corresponds to the model # in that row to appear. Any suggestions what I am doing wrong? See below for example
Table 1 Table2
<colgroup><col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2464;">
<col width="79" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2528;">
<col width="72" style="width: 54pt;">
<col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 2816;">
<col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2560;">
<col width="61" style="width: 46pt; mso-width-source: userset; mso-width-alt: 1952;" span="2">
<col width="72" style="width: 54pt;" span="2">
<tbody>
</tbody>
As a test, I set up to small tables. Table 1 contains two columns- model # and capacity. Table 2 contains 3 columns - model #, dim 1, dim 2. The two tables are related together via the model # columns.
I set up a pivot table that I want to show model #, capacity, dim 1 & dim 2. The first two items which come from the "master" table show up correctly, but the dim 1 & dim 2 which come from the "related" table come in to my pivot table as a list of all items in dim 1 or dim2 column for each row of data from Table 1. I want only the dim 1 and dim 2 that corresponds to the model # in that row to appear. Any suggestions what I am doing wrong? See below for example
Table 1 Table2
model # | capacity | model # | dim 1 | dim 2 | ||||
a | 10 | a | 10 | 10 | ||||
b | 20 | b | 20 | 20 | ||||
c | 30 | c | 30 | 30 | ||||
d | 40 | d | 40 | 40 | ||||
model # | capacity | dim 1 | dim 2 | |||||
a | 10 | 10 | 10 | |||||
20 | 20 | |||||||
30 | 30 | |||||||
40 | 40 | |||||||
b | 20 | 10 | 10 | |||||
20 | 20 | |||||||
30 | 30 | |||||||
40 | 40 | |||||||
c | 30 | 10 | 10 | |||||
20 | 20 | |||||||
30 | 30 | |||||||
40 | 40 | |||||||
d | 40 | 10 | 10 | |||||
20 | 20 | |||||||
30 | 30 | |||||||
40 | 40 | |||||||
Grand Total |