Two different expression in the same chart

[aunahsan]

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!

[sunny_talwar · Accepted solution]

May be try this

If(Year = 2017, MyExpression, OtherExpression)