I have three pivot tables created from the same data. When I group date information the grouping keeps affecting the other two tabs. I want 1 tab to be by month and the next tab to be by quarter but whenever I change the grouping it changes both tabs. Why are these tabs linked? How can I keep them seperate?
Pivot table- Tabs seem to be linked to one another
- Thread starter ptcoon
- Start date
- Joined
- May 20, 2011
- Messages
- 1,518
- Reaction score
- 1
- Points
- 0
- Location
- Mississauga, Canada
- Excel Version(s)
- Excel 2016
Did you copy the Pivot table to create the other 2 tables or did you create them separately?
I created them separately.
- Joined
- May 20, 2011
- Messages
- 1,518
- Reaction score
- 1
- Points
- 0
- Location
- Mississauga, Canada
- Excel Version(s)
- Excel 2016
Have a look at this article: http://www.pivot-table.com/2010/08/23/pivot-table-grouping-affects-another-pivot-table/
Thanks a ton as this article hit the nail on the head. I thought maybe there was something I was doing wrong or had wrong in a setting.
I really appreciate your help!
PC