Dependent page items in pivot table

  • Thread starter Thread starter TC
  • Start date Start date
T

TC

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?
 
Nope... All of the choices will dispay even though obviously some of them can
never be valid.
 
Thanks for the quick response.

Jim Thomlinson said:
Nope... All of the choices will dispay even though obviously some of them can
never be valid.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table filter list - listing irrelevant subcategorys 1
Why cant I exclude items with no data from the Page Field? 10
Pivot Table Help 1
Problem with Calculated item in Pivot Table 1
XL2007 - Pivot Table Limitations 2
Count(s) in Pivot Table 4
Dynamic PivotTable List 1
Why does same data value appear twice in rows of a Pivot Table 1

Back
Top