Pivot Tables

Hi there

I am workng on a workbook which has one main Slicer linked to many different pivot tables. I am looking for a way to update all the Pivot Table Fields of a specific area (in my case: "columns") while keeping all of the remaining areas (Filters, Rows and Values) as they are.

Example:

After right-clicking on a pivot table area, and selecting "show field list", it pops up as follows

Pivot Data Fields
...List of fields to add to report...


"Filters" "Columns"
Country AAA
Region


"Rows" "Values"
Names Count of A
Count of B
Count of C


In my case, many different Pivots like the one above are linked each other (through a Slicer).

"Values" field, of course, contains different data in any single pivot.

"Columns" area always contains the same field in commune for every single pivot.

I want to be able to change the "Columns" value in one pivot and getting all of the other ones updated as a result.

Is there a way to do that?

Thanks