Pivot Table with Pages

[Guest]

Hi TWIMC,
How do I make my pivot table pages only show items that relate to the above selection, e.g. if I have three pages REGION, COUNTRY, ZONE, then if I select Europe I want my COUNTRY list to only show countries in EUROPE.

TIA
KM

 

[Debra Dalgleish]

The page fields aren't dependent, and there's no way to change the
setting.

 

[rsdoyle]

Unfortunately, as far as I know this is true. I would
like MS to spend more resources on enhancements such as
this in future instead of so much thrust into HTML, etc.
They could sell more updates if they did that, since most
users that I know do not try to collaborate online, etc.

-----Original Message-----
The page fields aren't dependent, and there's no way to change the
setting.

that relate to the above selection, e.g. if I have three
pages REGION, COUNTRY, ZONE, then if I select Europe I
want my COUNTRY list to only show countries in EUROPE.