1 Reply Latest reply: Feb 8, 2018 12:16 PM by Sunny Talwar RSS

    Two different expression in the same chart

    Aun Ahsan

      Hello!

      I have a small problem that i am trying to figure out, any help would be great.

       

      I have a line chart that has Month-Year as its dimensions. Its a rolling 12 months figure.

      the problem is that i need to use two different calculations for the different years. is this something that's possible?

       

      so for the months March to Dec 2017 it uses a different calculation and for Jan-Feb 2018 it uses a different calculation.

      i have tried IF to say if with getcurrentfieldselections(Year)='2017', MyExression, OtherExpression)

       

      but it doesnt work until i click on the year 2017.

       

      Thanks allot!