Add Link in Table to Another Tab

[Anonymous]

Hi All,

I am planning to create a scorecard that summaries the metrics across different locations. Below is the mock-up. One quick question, I want to link the straight table to another tab. So when the user clicks on a value in the straight table, it takes the user to another tab / view, that shows a drill down table (filtered based on the user click).

For example, if the user click on Sales figures of Location3 .. the user should be taken to another tab that will have a detailed table and charts. And should be filtered by 'Location2' and 'sales'.

Has anyone done something like this ? Appreciate any help and pointers.

Thank you,

Note: Title edited by Community Moderator for clarity

[vishsaggi]

Try this? in your new sheet tab, sheet properties add this expression.... I am sure you have another table already added to this new tab.