Excel 2007: Pivot sharing same cache?

G

Guest

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel pivot record group 1
Pivot Table date format 1
Group in Multiple Pivot table 1
Pivot table wizards 2
Grouping Date Fields in Pivot Table 2
Problem inserting calculated pivot fields into Pivot Table (2007) 1
Pivot Table - NUMBER FORMAT option does not appear in field settin 3
Value filter missing in pivot table 3

Top