Dependent page items in pivot table

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?
 
J

Jim Thomlinson

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

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

Dealing with a Pivot Table (when I don't want to) 0
Slicers and Calculated Items in Pivot Table 2
Pivot Table Help 1
Page numbering with Merged Document and IF statements 1
Excel does not accept text format! 0
Why cant I exclude items with no data from the Page Field? 10
Excel 2007 pivot table: select multiple data easier 0
Space at end of multi page list to accommodate new entries 1

Top