Dependent page items in pivot table
 

Is there a way to make page items in a pivot table dependent? For instance,
with page items of State and City, is there a way to limit City based on
State chosen?

Dependent page items in pivot table
 

Nope... All of the choices will dispay even though obviously some of them can
never be valid.
--
HTH...

Jim Thomlinson


"TC" wrote:

Is there a way to make page items in a pivot table dependent? For instance,
with page items of State and City, is there a way to limit City based on
State chosen?

Dependent page items in pivot table
 

Thanks for the quick response.

"Jim Thomlinson" wrote:

Nope... All of the choices will dispay even though obviously some of them can
never be valid.
--
HTH...

Jim Thomlinson


"TC" wrote:

Is there a way to make page items in a pivot table dependent? For instance,
with page items of State and City, is there a way to limit City based on
State chosen?

Dependent page items in pivot table
 

Excel 2007 PivotTable
Dependent Page Lists.
A work-around.
http://www.mediafire.com/file/jhgqga...10_29_09a.xlsm