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.