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 wrote:
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
Contextures
http://www.contextures.com/tiptech.html