Mirror pivot table (expand/collapse)

[rvalle]

Hello,

Maybe someone can help me with this.

I have two pivot tables, both from a powerpivot datamodel, in the same worksheet; one shows sale results grouped by date and by category and brand (dates in columns, the rest in row fields), and the other shows some calculated measures (DAX like fiscal year to date, index, moving averages, etc), resumed in the same way than the first one.

The matter is that I have done it like this, because I found that just one pivot cannot show the measures and the sales values without repeating the first one for each date entry.

So how can i get both pivots to work together in terms of rows collapsing and expanding via VBA? or if it is possible to have just one pivot keeping the conditions explained before.?

Just mention that none of the vba methods I found in the web has worked. One of them, the one shown in the following link, works only for normal pivots but not for complex datamodels:

http://stackoverflow.com/questions/...t-mimic-each-other-in-terms-of-rows-expanding

Thanks in advance for your time and kindness!

Best regards.