Change multiple pivot tables simultaneously.

[nancymarmat]

I have qvw that contains multiple charts (pivot tables). Each has the same dimensions, but different expressions. When I expand, collapse, or select a particular row in one pivot table I would like the same selections made in ALL pivot tables. Is that possible?

Any help would be greatly appreciated.

[dplr-rn]

I believe you will need macros.

But can i ask if dimensions are exactly the same. Why not use 1 table instead of 2

[nancymarmat]

Each chart contains different expressions, such as sales, quantity, or cost. Each of these in turn have calculated columns based on age. When I make a selection in the Quantity table, I would like the exact same selections in the sales and cost tables. Does that make sense?

[dplr-rn]

apparently even macros cant help you. see below

how to get the expand status when the pivot table is expand