any help on this is much appreciated:

how do I get the attached pivot table to work? I'm trying to get the '2013 estabs' column pull in same data point as in the '2012 estabs' . Now it is giving the total for the entire source column in the source table. In the powerpivot window, i made a primary key column and linked the two tables but it's not working. hope you see what i mean. the actual tables are 80,000+ rows each and want to have about 10 tables of that size linked.

fadi

how do I get the attached pivot table to work? I'm trying to get the '2013 estabs' column pull in same data point as in the '2012 estabs' . Now it is giving the total for the entire source column in the source table. In the powerpivot window, i made a primary key column and linked the two tables but it's not working. hope you see what i mean. the actual tables are 80,000+ rows each and want to have about 10 tables of that size linked.

fadi