Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables/Charts and common filter | Excel Discussion (Misc queries) | |||
How do I consolidate 2 tables into 1 pivot report? | Excel Discussion (Misc queries) | |||
Pivot tables - Format Report | Excel Discussion (Misc queries) | |||
Pivot tables - Format Report | Excel Discussion (Misc queries) | |||
Filter multiple tables on the same sheet | Excel Discussion (Misc queries) |