Excel analyse data from two tab

Copper Contributor

Hello everyone,

 

I have data from 2 tabs in the same excel file. I would like to make a some in function of the value in one column.

 

I have different area with the same thickness and I have to have automatically the sum per thickness (esay with every thing one tab by pivot table but I am totally out with 2 tabs)

 

explanation i want to sum total area and equivalent area per thickness and per material.

Jordan_atg_0-1656078244458.png

 

Jordan_atg_1-1656078260111.png

 

What can be your solution ? 

 

Thank you very much all

 

Jordan 

2 Replies

Hi @Jordan_atg 

 

my proposal would be to load both source tables to Power Query, combine them and then create a Pivot table from this combined table 

Thank you, @Martin_Weiss 

 

Sorry to behind late, I don't this complement of excel. I will try to add it. And test our proposition