Multiple items on pivot page field to show on other pivot

[o4008]

I have two pivots coming from same data organized differently. These two pivots have the same Page Field.

My goal is, if I filter my page field in the main pivot table, the other pivot tbl will take the same items to filter.

I can do this with single item filtering easily - but I am having trouble doing it for multiple items.

Any help would be much appreciated.

[mojo249]

This works for me. I have 2 page fields - Date and Office.

Please Login or Register  to view this content.

[o4008]

Thanks! I wasn't very clear. I only have one page field, but my problem is, if I filter multiple items, for example: My page field is called "Fruits" and the dropdown consists of Apple, Lemon, Banana, Orange, Tangerine, Strawberry, and I choose multiple items, Lemon, Orange and Tangerine. When I do multiple items, the other pivot must have the same multiple item filters. I cannot seem to make it happen. I think it has something to do with making the items visible.

[adambevo]

Hi o4008,

I have the exact same issue, did you ever get to the bottom of it?

Adam

[arlu1201]

Adam,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

[adambevo]

Hi Arlette,

I don't think you're right on this one. I haven't asked a new question, just asked whether he ever solved his question.

[arlu1201]

Yes, i agree with you, but the thread is more than a year old and is not likely to get a response now.

If you create a new thread, you will get a solution much faster.