Filtering or linking Page Fields in an Excel Pivot Table
 

Dear all,

I would like to able to do the following:

If, for example, I have two page fields, one containing Gender, and
one containing Names, if I pick 'Female' as the gender I would like
the second page field to only display the items that belong to the
gender Female.

Im guessing I'll need to put some code behind the PageField_Change
event (Im guessing there is one), but Im not sure if this is the right
approach, or if there is a property of the pivot I can use.

Any suggestions or experiences with this gratefully received...

Cheers,

Nick