Dynamic PageField Items

[Guest]

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?

 

[Guest]

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.

 

[Guest]

I am trying to do the same thing with a pivot table. I can get the first
pagefield to change but my code won't go further. Did you get your pivot
table to work and if so how?