Multiple pivot tables on same sheet with common report filter

S

steveblack2006

Hi

I am using Excel 2007. I have table (Table1) on Sheet1 and I want to
create 2 or three pivot tables based on Table1 on Sheet 2. This is
fine, I can do it. The reason I have more than one Pivot Table for the
same data is to display the data various combination Report Filter,
Row Label and Column Label.

What I cannot figure out however is to keep the Report filter to be a
common for all Pivot Tables based on Table1. If I change Report Filter
for one Pivot Table (PT), other PTs to reflect the change. Is it
possible to do this? I have a feeling this would be possible only if
all three PTs have the same field set as Report Filter.

Please let me know your feedback.

Thanks in advance for all the help.

Regards
Aseef
 
B

Barb Reinhardt

Have you considered creating a dynamic range for the PivotCache you are using
from Sheet1 and use that for the Pivots on Sheet2?
 

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

Storing Multiple Selected Pivot Table Report Filter Values 2
change pivot table in code 3
Pivot Table Question 2
GETPIVOTDATA function on pivot filter 0
Update multiple pivot tables 4
Pivot Tables - delete rows from Master List 2
Change a pivot field based on another pivot field 10
How to re-sort a pivot table filter 2

Top