Multiple Pivot Tables in same worksheet

[AlphaBetaP]

I am trying to set up multiple pivot tables on the same data -- one worksheet
to routinely genrate updted reports or charts as data is added. Some charts
show trend data by year, which I get by grouping the date entries to "year."
Another report reflects seasonality, which I get by grouping by month.
However, whenever I change the grouping on one table or chart, it changes on
all others.
Any ideas?

So far, it seem like all other items remain particular to the table cjosen,
e.g. variables, value field settings, etc. but if there is anything else that
would behave like grouping, I nee to know how to keep that fixed as well.

Thanks,
Bob

 

[Debra Dalgleish]

If pivot tables are based on the same pivot cache, their grouping will
be the same.
Instead of basing the second pivot table on the first one, create the
second pivot table based on the source data. That should result in a
different pivot cache, and the grouping can be independent.

 

[AlphaBetaP]

Debra,
Sounds great, but I can't figure out how to use a different pivot cache. My
data (about 70000 lines) is in one of my work sheets in the same Excel (2007)
file. Is there a different or better way to manage this?

For now, I solved the problem with a work-around, by adding a second date
field = to the first that I can group differently.

 

[Debra Dalgleish]

Your workaround solves the problem, or you can add fields to calculate
the year and month, and use those in the pivot table, instead of grouping.
In Excel 2007 you can create a named range that's based on the Excel
table, and include a couple of blank rows at the end. Base the second
pivot table on this new named range, and it will have a different pivot
cache.