Need help relating 2 tables

[joe675]

Hello, I one table "actual sales" and another table "sales goal". I have columns for sales rep, product ID and month.

How do I create a relationship in these two tables? (I think that is what I need)

I want to be able to create a power pivot and pull the sales rep and actual and then pull in the goal.

I have uploaded a workbook with some sample data.

Could someone please help me out?

Thank you

https://skydrive.live.com/redir.aspx?resid=84AA25B86224666C!161

 

[miguel.escobar]

Here you go
https://dl.dropboxusercontent.com/u/54063091/act%20vs%20goal.xlsx

Hope this helps.

 

[joe675]

Here you go
https://dl.dropboxusercontent.com/u/54063091/act%20vs%20goal.xlsx

Hope this helps.

Thank you so much!

I knew it was something like what you did but could not figure it out.

 

[miguel.escobar]

glad it worked! don't forget that you can't use the fields from the sales (fact) table when pivoting. You need to use the one from the lookup table otherwise you won't be able to compute the right calculation for the goal amount.