Multiple pivot tables on same sheet with common report filter
 

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

Multiple pivot tables on same sheet with common report filter
 

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



" wrote:

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