I'm trying to put together a a dashboard, but I have a major problem. I want to show a chart with the YTD (year to date) and the other with the year over year (as per the image). I'm detaching the charts once I select the view, but when I close and reopen the file the detach option is gone, so I see all the charts filtered by the same view option
Also, is possible it possible for the charts below to filter on ProductA/B when clicking on the chart above?
Lastly, is it possible to have the chart showing the percentage variance. For example something like: