Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make 2 Pivot Tables in same items
Dear Sirs,
There are 2 PVTs in one worksheet, they are PVT1 and PVT2. They are 2 exactly same PVT. In page area, there are selections of shops, year. In the row area, there is month. In column area, there are categories and products. When I make different selections in categories and products in PVT1, I need PVT2 change as well. Can I do that? Can someone help? -- Dennis Cheung |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make 2 Pivot Tables in same items
There's a sample file here that you could adapt to your worksheet:
http://www.contextures.com/excelfiles.html Under PivotTables, look for 'PT0008 - Change Multiple Page Fields' Dennis Cheung wrote: Dear Sirs, There are 2 PVTs in one worksheet, they are PVT1 and PVT2. They are 2 exactly same PVT. In page area, there are selections of shops, year. In the row area, there is month. In column area, there are categories and products. When I make different selections in categories and products in PVT1, I need PVT2 change as well. Can I do that? Can someone help? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot tables: Calculated fields among *row* items | Excel Discussion (Misc queries) | |||
Name items in Pivot Tables? | Excel Discussion (Misc queries) | |||
Cycle through Pivot Tables with Pivot Items | Excel Programming | |||
ticked items on Pivot tables | Excel Discussion (Misc queries) | |||
Pivot tables - calculated fields and items | Excel Discussion (Misc queries) |