Jun 24 2022 06:46 AM
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.
What can be your solution ?
Thank you very much all
Jordan
Jun 24 2022 09:04 AM
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
Jun 29 2022 07:29 AM
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