Hi all,
I've been browsing and using your forums for a while and until now I've always found the answer by searching - unfortunately I can't figure this one out!!
I'm building a reporting dashboard for marketing campaigns. I have various pivot tables on different tabs (to keep things clean and so I can do other workings out for each metric on that tab). I am then pulling graphs through to a dashboard. In each of the pivot tables I have a filter to show different types of campaigns, e.g. Newsletter, trigger, adhoc. I would love to be able to control this from the dashboard, so that someone using the dashboard can just select what they would like to see. I imagine if this is possible it would have to be done for each graph individually, but that's fine.
So - anyone know a way of doing this? I guess it's like a toggle to control what the graph shows, but all it's really doing is changing a filter on a pivot table in another sheet.
My level of excel is probably low intermediate. I can use pivots, formulas fairly well, though I'm not a programmer so VBA etc. is a bit beyond me.
Thanks in advance.
Eddie.
Bookmarks