Linking pivot tables in a dashboard [message #488998] |
Wed, 12 January 2011 16:16 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9236f0953e20594c159e546a50ff6c80?s=64&d=mm&r=g) |
j052018
Messages: 2 Registered: January 2011
|
Junior Member |
|
|
I have two pivot tables in a dashboard & would like to know if it is possible to update both tables when selecting a page item in one. For example, Pivot A shows sales by region and Pivot B shows salespersons by region. If I select a region in the page section of Pivot A, I would like to have region in Pivot B page section updated to the same region. Is this possible, or is there a better way to accomplish this?
Note: I am also showing ranking across all regions in Pivot Table B. I tried using a filter to accomplish the purpose stated above, but found the ranking was then only for the filtered region & not across all regions.
Any info/assistance is appreciated.
|
|
|
|
|
|