This content has been marked as final. Show 3 replies
Robert Angel wrote:Little detail was provided to debunk what I am about to say, so if it doesn't apply, then ignore.
Is it possible to Synchronise two independent reports behaviour such that when one column selector value is changed the other follows suit, kind of like the master / detail behavior that is possible with sliders.
But is it possible to put all the columns in both reports in criteria, then create two pivot tables, one that simulates the first report, and a second pivot table to simulate your other report.
Put both pivot tables one on top of the other in the Compound Layout view and the Column Selector at the very top. This will change out the columns in both tables, basically satisfying what you are trying to achieve.