Join two pivot table in a sheet

[jeo varghese]

Dear sir
Please find the attached file, in that two pivot table generated from two database.
How we can add together on the base of Phase ID
Please help me
Thanks and regards
jeo

 

[prasaddn]

Hi,

Will GetPivotdata help you?

If you keep your PT to match your requirements then you can try GetPivotdata and acheive the same.

Check the example attached.

Regards,
Prasad DN

 

[prasaddn]

Hi,

you could use getpivotdata function if you keep both the PTs in consistent format and you put your requirements correctly in the formula.

check the examples in the attachment.

Regards,
Prasad DN