Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
May be try this
If(Year = 2017, MyExpression, OtherExpression)