Pivot Table with Pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
Click to expand...
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.
 
Back
Top