software

I have source data that comes from massive SQL databases, and create several
pivot tables using this same source data. The data is brought into the
worksheet so I can quot;drill downquot; to see detailed data.

I group my first table by month. I also make quot;otherquot; groupings of other
data. I then copy the table and paste it in a new location so that the size
of the worksheet is minimized by using the same data in all pivottables. The
quot;otherquot; groupings remain intact.

The problem I have is that I change the second pivottable to weekly
groupings of the data (not monthly). The quot;otherquot; groupings stay intact, but
the it then changes the first table to weekly groupings.

How can I group monthly/weekly data differently, but still minimize the size
of the pivottable and keep the quot;otherquot; grouping intact?

My ultimate goal is to be able to group multiple fields, and use those
groupings in many different pivottables, and minimize the size of the
worksheet (I know I could draw the data differently by adding or subtracting
fields, but then I must maintain groupings in all my pivottables...but the
groupings occasionally change and maintaining those groupings in 100's of
pivottables is very time consuming).

I hope I make sense. There must be a way to deal with all this!!

For all pivot tables based on the same pivot cache, the grouping is the
same. Perhaps you could record macros to group the date fields in a few
standard ways, then run those as required.

Todd1 wrote:
gt; I have source data that comes from massive SQL databases, and create several
gt; pivot tables using this same source data. The data is brought into the
gt; worksheet so I can quot;drill downquot; to see detailed data.
gt;
gt; I group my first table by month. I also make quot;otherquot; groupings of other
gt; data. I then copy the table and paste it in a new location so that the size
gt; of the worksheet is minimized by using the same data in all pivottables. The
gt; quot;otherquot; groupings remain intact.
gt;
gt; The problem I have is that I change the second pivottable to weekly
gt; groupings of the data (not monthly). The quot;otherquot; groupings stay intact, but
gt; the it then changes the first table to weekly groupings.
gt;
gt; How can I group monthly/weekly data differently, but still minimize the size
gt; of the pivottable and keep the quot;otherquot; grouping intact?
gt;
gt; My ultimate goal is to be able to group multiple fields, and use those
gt; groupings in many different pivottables, and minimize the size of the
gt; worksheet (I know I could draw the data differently by adding or subtracting
gt; fields, but then I must maintain groupings in all my pivottables...but the
gt; groupings occasionally change and maintaining those groupings in 100's of
gt; pivottables is very time consuming).
gt;
gt; I hope I make sense. There must be a way to deal with all this!!--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html