one pivot table from two different excel table

[urvota]

Hy Everybody,

I am sure somebody can help me:

I have an Excel Table with Price Data - Product Name, Quantity (piece, weight, etc), Price in Dollar, Price in Euro.
I have an additional Excel Table with 7 Sheets (one weekday each), with Product Name, Company, Sale

My Question is, how can i make a Pivot Table (one for the hole week) together with the Price Data?

Thank You in advance
Regards
Tamas

 

[sandy666]

without seeing the data/structure I can't say more than: try Alt+D+P

 

[mykeee]

Hy Everybody,

I am sure somebody can help me:

I have an Excel Table with Price Data - Product Name, Quantity (piece, weight, etc), Price in Dollar, Price in Euro.
I have an additional Excel Table with 7 Sheets (one weekday each), with Product Name, Company, Sale

My Question is, how can i make a Pivot Table (one for the hole week) together with the Price Data?

Thank You in advance
Regards
Tamas

Would you be able to create another table that pulls the data from the other two tables using formulas and then create the pivot table from that?

 

[ClaireS]

Consolidate the sales data into a single table using Power Query or Data, Consolidate. Then start a Pivot Table based on this, and Add this data to the Data Model when you are creating the Pivot Table. This will allow you to display the Price data along with the matching Product information.