All,

Can I get some good reference material which should explain hide/show sheets through action?

Say for example, I have 3 sheet.

Sheet 1: All Departments ( Bubble Chart)

Once I click one any one department, I have to display top 5 students from that respective department in Pie Chart.

Sheet 2: Top 5 Student (Based on the action from Sheet1 )

once the pie chart came, I should have an option there to display details of all department and its all students ( More like table chart). This one will be opened in a new tab.

Actually ,I just designed this scenario only for forum purpose ( As I can't share my actual data). Once I get the solution, I have to implement the exact logic in my actual dashboard.

Thanks

Karthik M