Activate sheet based on cell selection

[#1]

Hi All,

I have a requirement where I have one dashboard tab and other metric specific tab where the detail data is being desplayed.

Dashboard tab has a straight chart with 3 or more expressions (metrics) and i have corresponding tabs for each metric.

I want to activate the correspoinding tab based on the cell selection and also pass the selected demension values.

I have attached a example qvw.

What all possible ways I can do this?

Thanks in advance,

Anosh Nathaniel