If you search the Forum you will find countless threads related to controlling multiple pivots simultaneously - there are (IMO) differing layers of complexity pending version and required actions...
Here at least the requirements "seem" straightforward enough... ie a single page/report filter with a 1 / All type approach where data source is identical, on which basis perhaps something like:
it's not clear to me if the page filter is sourced from the same field or not ?
if so, simply change that above in red to reflect the required field name... if not you should I think be able to adapt the above as required by adjust strField as appropriate
Note: the above also assumes PTs are located on the same sheet... unspecified
(the above code would reside in the Sheet Object on which the PTs exist - right click sheet name in XL - View Code - paste above into resulting window)
Bookmarks