10 Replies Latest reply on Sep 8, 2018 8:22 AM by carlos capella

    How can I filter an aggregated value in a dual axis chart?

    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.

       

      I have tried with:

      IF Year='2018' THEN [aggregated value] END      (for one axis)

      IF Year='2018' THEN [aggregated value] END      (for the other one)

       

      But it returns this error: 'cannot mix aggregated and non-aggregated comparisons or results in IF expressions.

       

      How can I solve this? 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.