Power Pivot Tables
Power Pivot Tables
(OP)
Hi, I have created a one to many relationship. When create my Power Pivot Table, every value from the second table is shown for each value of the first.
For example.
If my primary key is Street Address. Table1 has only one record for each street address. Table2 has multiple records for each street address. So I created a one to many relationship between the two tables. Table 2 also has a "Property Name" field. There is only one property name from each street address in table 2. Unfortunately, when I add property name from Table2 to the Power Pivot Table, every value of Property Name from Table2 is shown for every Key value of "Street Address".
SHOWN:
1 Colonial Street
Maple Downs
Gables
29 Fisher Street
Maple Downs
Gables
SHOULD BE:
1 Colonial Street
Maple Downs
29 Fisher Street
Gables
Any ideas what could be going wrong. My example is simplified, but the problem is happening with about 50 addresses and 50 property names shown for each address.
Thanks.
For example.
If my primary key is Street Address. Table1 has only one record for each street address. Table2 has multiple records for each street address. So I created a one to many relationship between the two tables. Table 2 also has a "Property Name" field. There is only one property name from each street address in table 2. Unfortunately, when I add property name from Table2 to the Power Pivot Table, every value of Property Name from Table2 is shown for every Key value of "Street Address".
SHOWN:
1 Colonial Street
Maple Downs
Gables
29 Fisher Street
Maple Downs
Gables
SHOULD BE:
1 Colonial Street
Maple Downs
29 Fisher Street
Gables
Any ideas what could be going wrong. My example is simplified, but the problem is happening with about 50 addresses and 50 property names shown for each address.
Thanks.
Talk To Other Members
RE: Power Pivot Tables
Need to see the relevant row(s), including column headings, for each table, not just the result you get or desire.
Also, what application are you using?
Skip,
for a NUance!
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein