help with creating relationships, new to power pivot

[IloveDeathMEtal]

Hello Everyone, I am having trouble right now creating a relationship between two tables that I am trying to link. First, I would like to mention i'm using 2010 with version 2012 sp1 power pivot.

what i am trying to create is two tables for based on nba teams and their respective conferences. I have one table named tblConference
[TABLE="width: 500"]
<tbody>[TR]
[TD]Conference ID[/TD]
[TD]Conference Name[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]East[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]West[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

and one table named tblTeams

[TABLE="width: 500"]
<tbody>[TR]
[TD]Team ID[/TD]
[TD]Team Name[/TD]
[TD]Conference ID[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Lakers[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Warriors[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Heat[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Knicks[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Magic[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]spurs[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]mavericks[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]rockets[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]clippers[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]wizards[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

thus, when I create the relationship and I put it into a pivot table, with row labels (in this order) conference name-> Team Name, The pivot table does not separate the teams based on their conference instead both the east and west conferences receive all the teams. Can somebody tell me what I'm doing wrong? Also if someone would like to see a sample excel sheet, how do i attach the sheet to this post?

 

[theBardd]

That is because you don't have an aggregation in the Values pane in the pivot, nothing in the model to aggregate. If for instance you added the Team ID into Values and changed the aggregation to count, you see 4 in the East, 6 in the West.