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 |
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) |