Grouping of Pivot Tables based on same data

[annikatammiste]

I have two pivot table that are based on the same data. How can I change the grouping in only one of the tables without it changing the other?

[MarvinP]

Hi annikatammiste and welcome to the forum,

Create two different named ranges that span your data. Created your first Pivot using the first name and the second using the second name. Now the first Pivot shouldn't interfere with the second.