I have a dashboard with three sheets(A, B, C) and I have a Filter which is same across all the sheets. So if I select a options from that filter the metrics will change according to the selected filter across all the sheets.
I got a requirement where if I opened a dashboard first sheet A needs to be seen with a selected filter.
For Example
Three Sheets = A, B, C
Filter has = Company, Sales, Output
Requirement =
A sheet need to shown with Sales as filter selected when you open a dashboard.
Create a bookmark with sheet A as the active sheet and with the necessary selections and open the document by its url with the bookmark as parameter like explained in this discussion: Passing Parameters in a URL and Document Chaining
