Can I add a 2nd pivot table to the same worksheet as the 1st

[Trebor777]

Hi. I have a pivot table based on a worksheet. No problem. I would like to add a 2nd pivot table based on the same table but with different columns (fields) selected. Can I put the 2nd pivot table in the same worksheet as the 1st ?

If so, can I do it by copying the 1st table, pasting it to a new position, then simply changing the selected fields ?

Many thanks

KK

[xlnitwit]

Hi,

Yes to all those questions. As long as you know the pivot table layouts won't change much you should be OK- one pivot cannot overlap another and they do not automatically insert rows/columns when they refresh.

[Trebor777]

Many thanks, all is good. K