I have two pivot tables based on the same source.

However, each table is unique in how it shows the date. The first shows all
thirty days of the month. The second groups the date in 10 day increments.

The first table is summed data while the other is averaged data.

When I try to set up the second table to group, it also groups the first
table even though its' on a different sheet. I remember being able to do this
in version 2003.

What have I overlooked?
Thanks

Phil