I have 2 pivot tables and need to add all the total in the 3rd table

[#1]

Hello Experts,

I have 2 pivot tables and I need to add the value of the first cell of the first table + first cell of the second table and place it on the 3rd pivot table in another sheet #note.

am also doing this for Sub-Totals adding the 1st + 2nd table sub total and place it in the 3rd table in pivot table in another sheet.

also for the grand total

See snapshot of my pivot table

[alexandros17]

Unfortunately it is not possible unless you replicate all the fields in the 3rd pivot table

[#3]

Oops!