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 |
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 |
All times are GMT +1. The time now is 12:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com