Filtering or linking Page Fields in an Excel Pivot Table

N

Nick Weekes

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Template with fields and premade texts.. 0
Page numbering with Merged Document and IF statements 1
Need some PWA help 0
Nested Pivot Table 1
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
Create a chart from a table in word thats dynamic 0
Using Pivot Table to analyze multiple variables in satisfaction survey 1
Cumulative formula for word table 0

Top