Hi, I have a huge problem in getting my PivotTable to work fine with multiple tables. What i want to achieve is a table that display total sale per month of a team of people where everyone has their own table with sales. The team consist of 10 ppl so I have ten different tables containing the data och their sale.

Month - Itemname - Sum

Now I want to sum of the sale of each item and display i per month, so the columna will have the months and the rows contain the different items.

When I try to do it I get a sum of the values from each table under each month, so with 10 ppl I get 10 columns wuth values under each month, but I want to have them summed up.

What am I doing wrong?

Regards,
GF