Functionality similar to action filters in Tableau.

[Anonymous]

i have 2 sheets , the summary  sheet and the details sheet. Summary sheet contains a bar chart showing 'Region vs Sales'.and the details sheet contains individual datewise sale records of all regions . I want a functionality like :

When i click on any bar corresponding to a particular region it should go to the next sheet automatically filtering the details only for that particular region.

Can anyone help me on this?

Thanks in advance

[robert99]

Hi

As far as I understand it can't be set up as an automatic link. So the options are

• Either include both charts (bar chart and table) on one sheet or
• Use the KPI chart and set up as I have done below below (also use link to sheet under presentation)
• There may be an extension that does this

[Anonymous]

Hi Robert,

Thank you for the reply.

But is it possible for some workaround where we can directly click on the bar and the navigation get triggered.?