1 Reply Latest reply on Sep 8, 2018 6:17 AM by Zhouyi Zhang

    How can I make a dual axis with aggregated and non-aggregated measures?

    carlos capella

      Hi,

       

      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.