Forum Discussion
Sort the two disconnected matrix at the same time
Anonymous - Not that I'm aware of. I'd love it if MS opened up some kind of JavaScript or other scripting language we could work with to drive these button click type events across our reports, but at the moment I just live with bookmarks.
Out of curiousity, what makes the bookmark idea unusable? Would be fairly quick and easy to setup.
Solution SupplierHi Anonymous,
The only way I can think to do this is to set up bookmarks that are linked to only the 2 matrix visuals and set the bookmarks
- First bookmark when both are sorted ascending
- 2nd bookmark when both are descending
Make sure to use the Selected Visuals options (highlight the 2 tables when creating the bookmark) on the bookmarks and only have the data item checked on the bookmark.
Then stick a couple of buttons above and assign these as an action.
Extra credit - You could get really fancy and have the 2 buttons layered on top of each other and set the visual properties of these to hidden or not when each is clicked, saving a bit of screen real estate.😉
Hope it helps
Kris
is there anyother way ?
- kriscoupe
Anonymous - Not that I'm aware of. I'd love it if MS opened up some kind of JavaScript or other scripting language we could work with to drive these button click type events across our reports, but at the moment I just live with bookmarks.
Out of curiousity, what makes the bookmark idea unusable? Would be fairly quick and easy to setup.