Dynamic PageField Items

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?

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" wrote:

> 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?
>

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



"Patrick Molloy" wrote:

> 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" wrote:
>
> > 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?
> >

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?

"DynamiteSkippy" wrote:

> 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?
>