Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I believe you will need macros.
But can i ask if dimensions are exactly the same. Why not use 1 table instead of 2
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?
apparently even macros cant help you. see below