Prev: HOW CAN I SORT SUBTOTALS FROM HIGHEST TO LOWEST
Next: one cell in my worksheet appears blank, but answr shows in formula
From: PEGWINN on 9 Apr 2010 10:55
I have a table for inventory. It has 31 rows as one per day. It has a column
for each product, about twenty or so in all.

I can create the PT without a problem.
But if I create a second PT based on the same table, even if I place it on
it's own worksheet, all the variables change on both pivot tables.

Example:

PT#1 Requires the Date as Row Headers, grouped in 10 day increments, and
certain but not all products represented in columns with various calculations.

PT#2 Requires the Date as Row Headers, grouped in 5 day increments, and
certain (different) but not all products represented in columns with various
calculations.

As soon as I set the Date group in PT#2 to 5 day increments, it changes the
10 day to 5 day as well in PT#1.

Also I may need the same field summarized via sum in the first PT but
averaged in the second. I haven't tried it yet, but if the grouping is
global...... is that going to be a problem?

All advice or reading recommendations greatly appreciated. Thanks folks.
Phil
From: Herbert Seidenberg on 9 Apr 2010 17:26
Excel 2007 PivotTables
Same source, independent grouping.
http://www.mediafire.com/file/nmyxwnmkdma/09_23_09.pdf
 | 
Pages: 1
Prev: HOW CAN I SORT SUBTOTALS FROM HIGHEST TO LOWEST
Next: one cell in my worksheet appears blank, but answr shows in formula