How to remove current year line value on data point ?

[#1]

Hi All

My chart only have 1 expression. and it display 2013 sales trend and 2014 sales trend.

I only want 2013 sales value display at data point , how to do it ?

[jagan]

Hi Paul,

Try like this

<Year={$(=year(today()))}>

Regards,

Jagan.

[#3]

Hi Mohan

if(<Year={$(=year(today()))}>,lightgray(),yellow())

I try the above expression it still not work.

Paul

[jagan]

Hi,

Then try like this

if(<Year=year(today()), lightgray(),yellow())

Make sure that Year and Year(Today()) values are in same format, i.e,

For example : 2014 in Year field and Year(Today()) = 2014

Regards,

jagan.

[#5]

Hi Mohan

Thank you very much. but today i no luck . will try again other day.