consolidate using pivot table

[lezawang]

Hi
I have excel 2013. I want to consolidate date from 3 different sheets using pivot table not data-->consolidate tool. so i created these 3 tables and insert Table1, Table2, and Table3.
I was inside Table3, I clicked insert Pivot and checked Allow Data Model.
In pivot table, I created Relationship Table 3 -->item, table1-->item
and Table3-->item, table2-->item

I expanded Table one and move Item to Rows
and Jan to Values

Then opened Table 2 and moved Jan to Values
but excel is asking me to Create Relationship which I already did. Alos
How can I added all these values and create table like below using pivot table?
Thank you so much

item	jan	feb	mar
item1	1	1	1
item2	1	1	1

<tbody>
</tbody>

item	jan	feb	mar
item1	2	2	2
item2	2	2	2

<tbody>
</tbody>

item	jan	feb	mar
item1	3	3	3
item2	3	3	3

<tbody>
</tbody>

I want

item	jan	feb	mar
item1	6	6	6
item2	6	6	6

<tbody>
</tbody>

The file is here:

https://drive.google.com/file/d/12mX4V7VpNkC2m-CMyrhIKvy4Y0wk6BAg/view?usp=sharing

 

[sandy666]

maybe try Alt+D+P

Sum of Value	Column Labels
Row Labels	jan	feb	mar	Grand Total
item1	6​	6​	6​	18​
item2	6​	6​	6​	18​
item3	6​	6​	6​	18​
item4	6​	6​	6​	18​
Grand Total	24​	24​	24​	72​