Excel 2007: Pivot sharing same cache?
 

Discussion/Problem
Basically when I generate different pivot tables starting from one table
(List in excel 2003), it seems impossible to group the field date in one
pivot without affecting all the others: group in quarter and all the other do
the same, ungroup and all ungroup.
If it can help:
The file is in .xlsx format, but the table was created in excel 2003
The format of the date in the table is (mm/dd/yyyy) and is dropped in the
pivot raw field. Actually the date column is calculated as =DATE(Ax,Bx,Cx).
I tried to check and uncheck save source data with file.
Any hints?
I read a similar post under chart that had no replay I wonder why.

Excel 2007: Pivot sharing same cache?
 

I put the pivot command wizard in the quick access toolbar and i generated a
Pivot, the cache is separate and now i can group without affecting others
pivot. Still wondering how to do it using the command PivoTable in the ribbon.
Andrea

"Andrea" wrote:

Discussion/Problem
Basically when I generate different pivot tables starting from one table
(List in excel 2003), it seems impossible to group the field date in one
pivot without affecting all the others: group in quarter and all the other do
the same, ungroup and all ungroup.
If it can help:
The file is in .xlsx format, but the table was created in excel 2003
The format of the date in the table is (mm/dd/yyyy) and is dropped in the
pivot raw field. Actually the date column is calculated as =DATE(Ax,Bx,Cx).
I tried to check and uncheck save source data with file.
Any hints?
I read a similar post under chart that had no replay I wonder why.