operation between two cells from different pivottable + drag

[andrew1980]

Hello there,
I've got an issue where I'm losing so much time..

I try to do a multiplication between two different cells in two different PivotTables and I want to be able to drag the result of the operation but I can't, Is there a way to to do so?

for eg;
on G1 sheet 3: A1 from pivottable sheet 1 * B1 from pivottable sheet 2

then I want to drag G1 down so A2 sheet1 * B2 sheet 2 etc..

I hope I'm clear..

Thanks in advance