×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Power Pivot Tables

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.

RE: Power Pivot Tables

Hi,

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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close