Action filter !
I am aware if the ACTIOn FILTER but, the concern is I need , for each categories corresponding report will pop up.
for eg when I select Customer .. Customer details should display
When I select Stationary its corresponding details shud display
and if clicked on Locations then its details...
How do we do this using Action Filter... since Our source dashboard is one
Source sheets can be separated to get the desired redirects..so have the source dashboard with 3 worksheets stiched together. and clicking on respective sheet will guide the redirects
In your case. Customer, Stationary, Location can be created as separate worksheets. Assemble them on the source dashboard 1 in such a way that they look like a single worksheet. Then define the action filter