How do I create unique pivot tables from the same data

P

PEGWINN

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
How do I freeze the swimlane headers? 0
Multiple Pivot Tables based on the same data 3
Change report firlds in pivot tables and charts with one selection 0
Link Pivot Tables on one filter 2
How to have two tables on same line? 1
Pivot Refresh Error when calling Excel Macro from VB.NET program 0
Pivot Table Does Not Show Data 2

Top