Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
One Pivot Table changes another
I have two pivot tables. One is based on the other, so the data for
both of them is identical. However, I want the second pivot table to change when the first one does. For example, the user chooses a pull down for one of the fields and unchecks an item (hides it). I'd like that same item to be hidden on the second pivot table. Could someone tell me how to do this? tod |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
One Pivot Table changes another
There's a few sample files here that you could adapt to your worksheet:
http://www.contextures.com/excelfiles.html Under PivotTables, look for PT0016 - Change Page Fields With Cell Dropdown PT0015 - Change Multiple Different Page Fields PT0008 - Change Multiple Page Fields todtown wrote: I have two pivot tables. One is based on the other, so the data for both of them is identical. However, I want the second pivot table to change when the first one does. For example, the user chooses a pull down for one of the fields and unchecks an item (hides it). I'd like that same item to be hidden on the second pivot table. Could someone tell me how to do this? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non Pivot table columns | Excel Discussion (Misc queries) | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |