Pivot Table Page Field Filtering

[Dimi]

Hi,

I think I have found a bug, but would like confirmation.

I have a pivot table that has 2 page fields. I am expecting the list of the
second page field to be filtered based on the selection of the first page
field (similar to what happens to the body of the pivot table when an item is
selected). I have noticed there is an Auto sort option available in the field
options of page fields, but there is no similar Auto filter option.

For example,

Page Field 1 has the following list available
Series 100
Series 200
Series 300

Page Field 2 has the following list available
101
102
105
201
203
300
301

When I choose the Series 100 value from the first Page Field I expect only
values 101,102 and 105 to be available for Page Field 2, unfortunately all
the values of Page Field 2 are able to be selected - even though they are not
logically related (ie 101....301). How can I limit the selection of Page
Field 2 to only allow the items that are logically related?

Many Thanks,

Dimi.

 

[J. Sperry]

I've got the same situation. My pivot table has company names, along with
divisions within companies. When I filter for Company ABC, I only want
Company ABC's divisions listed in the division filter. This would avoid the
awkward result of a user filtering on unrelated company and division names
and getting no data.

In a previous job, I recall doing this in a MS Access form with listboxes
and AfterUpdate events. Any solutions for an Excel pivot table? (seeing
some VBA code in my future...)