Hi,
This is annoying and I'm sure there is someone trying to achieve the same thing but I don't and unfortunately it is happening.
So two pivot tables (PT), same source data.
The first PT is using a date field grouped by Year / The second one used the same field but I want it to be grouped by quarter for further processing.
When I change one the second gets modified as well!
Annoying?!!
Thanks
that's because they are using the same pivotcache. create the second pivot table using the pivot table wizard (alt+dp) and choose no when prompted to base it off an existing pivot. it will make your workbook larger
Josie
if at first you don't succeed try doing it the way your wife told you to
you guys are quick .. great!
I'm using excel 2007 the French version alt+dp doesn't work for me?and I don't see any mention of (P)ivot table in (d)ata menu
Thanks
I don't know what the shortcut is in French excel but you can add the pivot table wizard to the quick access toolbar and then click that
Got it .. it works now .. Many Thanks!!
you're welcome :-)
please don't forget to mark the thread solved (click the 'thread tools' link at the top then click mark solved)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks