Dynamic PageField Items

[DynamiteSkippy]

I am trying to build a pivot table/chart in which the PageFields will only
list the remaining or available PageFieldItems after other choice
PageField--constraints--are applied.

For example:
Having the PageFields:
Baseball Teams
Players
And when a specific team is chosen only players on that specific team are
shown.


Brain Storm:

My thought is to build a combo/dropdown box to replicate the page field and
then take the values assigned to that and then do a custom filter to develop
a new list which subsequently populates the combo/dropdown box. Meanwhile
take any choice values and apply them toward pivot table/chart build.

Does anyone have any ideas? Am I reinventing the wheel?

 

[Patrick Molloy]

here's a worksheet tip that might help.
Once you have your pivot, select a cell immediatelyto the right of the
column headers, then hold down control and select the header cells to the
left, now add an autofilter. Works on the pivot as if it were a regular table.

 

[DynamiteSkippy]

I appreciate the tip. Autofilter work on the pivot tables as if they are a
regular table. That was one of the ideas that I tried out however
PivotTables aren't like regular tables in that not all data is visible.
AutoFilter requires a list of data and then it summarizes the list and
enables you to filter along that criteria. PageFieldItems have an invisable
list--PivotCache--and thus filtering by cell contents has no impact on the
other PageFieldItems.

Also AutoFilters don't like working with segmented ranges so I think you
meant to hold down the SHIFT button.

So that is what brings me back to square one. I think I am going to have to
re-engineer a pivot table-esque form that will actually filter on a
high--page--level as well as on the column and row level.

I really appreciate the tip. I keep thinking there should be some little
nifty trick already build in to some option menu or something that would
solve this.

Thanks
-D