I have a dual axis chart with the same aggregated value for both axis. I want to filter one value by Year=2017 and the other one by Year=2018.
Please find attached the workbook.
I know that one of the workarounds is duplicating the data source, but I can not do it because I need the database to be updated in real time.
Thanks for your help.