use a single report filter for multiple pivot tables

[cslinger]

Lets say I have four seperate pivot tables. Lets say the pivot table area all pulling from a single source of data that contains the following data. (I am just making up something simple for our purposes)

Car Brand
Number Sold
Defects Encountered
Positive Reports
Negative Reports
Etc.

So lets say on sheet 1 I want a PIVOT table that gives me the total number sold and percentage of such whatever. The point is the report field should be car brand.

Now lets say pivot table number two is to show the number of positive and negative reports, again with car brand being the report filter.

What I want to be able to do is simply choose car brand as a report filter a single time on sheet 1 and have it carry over to my subsequent sheets/pivots.

Is this possible?

Thanks
Chris

[mhuston]

If you keep the data structure the same and add code to refresh the pivottable upon sheet selection, you could do it if PivotTable 2 was pulling from PivotTable 1.

[Ron Coderre]

See Mike Alexander's video tutorial on synchronizing pivot tables.
http://www.datapigtechnologies.com/f...s/pivot10.html

Does that help?

[cslinger]

Perfect, thank you very much. Been looking for this for quite some time.

Chris

[SaiDon]

See Mike Alexander's video tutorial on synchronizing pivot tables.
http://www.datapigtechnologies.com/f...s/pivot10.html

Does that help?

With this method only resolve filter that is selected one value.

Please help me resolve with filter can select multiple values!

Thanks

[arlu1201]

Saidon,

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.

[SaiDon]

sorry for my question. Thanks