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
Bookmarks