Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link "page-by" drop-down in two pivot tables
Is it possible in Excel to select an item within a page-by in a pivot
table and have a subsequent pivot table with the same drop-down pull the data for that selected item? For example, let's say I select CA in a pivot table and the data come up. And I also have another pivot table with State as the page-by. Is it possible to link the 2 tables such that data for CA would pop up for the second one automatically? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Link "page-by" drop-down in two pivot tables
There's a sample file here where changing a page field in one pivot
table programmatically changes the same field in other pivot tables: http://www.contextures.com/excelfiles.html Under PivotTables, look for 'PT0008 - Change Multiple Page Fields' wrote: Is it possible in Excel to select an item within a page-by in a pivot table and have a subsequent pivot table with the same drop-down pull the data for that selected item? For example, let's say I select CA in a pivot table and the data come up. And I also have another pivot table with State as the page-by. Is it possible to link the 2 tables such that data for CA would pop up for the second one automatically? Thanks. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
overlapping pivot tables | Excel Discussion (Misc queries) | |||
grouping in pivot tables | Excel Discussion (Misc queries) | |||
Grouped Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Multiple Pivot tables from One selection | Excel Discussion (Misc queries) | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) |