I'm trying to navigate from one work sheet to another by clicking on a dimensional column. It doesn't really need to pass any values and filter, I am just looking to jump to a different page by clicking on a dimension, having a menu pop up and selecting the page I would like to go to.
Is that possible?
Jumping to a different tab does not work quite like you've described. However, it is possible using actions and creating a "Table of Contents."
Hope this helps!