Link "page-by" drop-down in two pivot tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

robotman@gmail.com - 27 Oct 2006 23:40 GMT

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.

Reply to this Message

Debra Dalgleish - 28 Oct 2006 03:44 GMT

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'

> 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
[quoted text clipped - 4 lines]
>
> Thanks.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message