Power Pivot Starting

[guexc1977]

Hello,

First and foremost, thank you all for helping with my many Excel questions. I use VBA from time to time but I've never used Power Pivot (PP) before. In an effort to get accustomed to PP, I decided to create two simple tables, add them to the data model, create a pivot table from PP on them, and see what happens.

The tables are:

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Color[/TD]
[TD="width: 64"]Animal[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD]Tiger[/TD]
[/TR]
[TR]
[TD]Yellow[/TD]
[TD]Dolphin[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD]Turtle[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]Snake[/TD]
[/TR]
</tbody>[/TABLE]

and

[TABLE="width: 135"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Color[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD]Red[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Yellow[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Blue[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD="align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]

I simply tried to create a relationship on "Color" and then make a pivot table. Yet, when I attempt this, it doesn't create an expected 1-to-1 relationship. It puts all four numbers below each color? I'm not sure why this would be.

Thank you.