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

    Two different expression in the same chart

    Aun Ahsan


      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!