Hello There

I hope this is just a really simple one!!

I have a created a pivot table and grouped the rows (salaries) by £5000. I have then created a new pivot table with exactly the same data but group by £10000. Both of these pivots were created on new sheets.

When I look back to the original table that has now been grouped by £10000. They seem to be linked in some way even though they have been created independently.

Does anyone know if there is a way of getting around this other than just creating a duplicate salary field and using 1 for the 1st pivot table and the other for the second pivot table?

Thanks in advance.

Jim