Power Pivot New User

[Brenda Carr]

Help I am having trouble creating the pivot table from two different work sheets. I am uploading a Sample File that has Customer List Table and Customer Part Number Table. When I try to run the pivot table to show customer code with customer name I am pulling the code and all the Customer names in the Customer Part Number table (see snapshot). My relationship is Customer Name to Customer Name so I am not sure what I am doing wrong. Can someone help. Thanks in advance.

 

[NARAYANK991]

Hi ,

Since your workbook has been created in Excel 2013 or later version , those who have Excel 2010 and use Power Pivot will not be able to work with your file.

Is there any possibility of saving it so that those with Excel 2010 can work with it , and then uploading it ?

Narayan

 

[Brenda Carr]

Hi ,

Since your workbook has been created in Excel 2013 or later version , those who have Excel 2010 and use Power Pivot will not be able to work with your file.

Is there any possibility of saving it so that those with Excel 2010 can work with it , and then uploading it ?

Narayan

 

[Brenda Carr]

Thanks Narayan, I appreciate you looking at the file.