Line Chart

[#1]

Hi Experts

I have the following problem:

I want to display sales data of 2014 and the current year in a cumalative line chart. Of course, for 2015 there is only data for January and February. But the line is continued at the same level until December. How can I prevent this?

Thank you for your help!

Jan

[MK_QSL · Accepted solution]

Go to the Expression Tab and for 2015 click on +

Under Background color, write below condition

IF(Month<= Month(Today()),Blue(),White())

[sunny_talwar]

What expression are you currently using for 2015? May be there is a way to restrict the line within the expression itself.

Best,

S

[#4]

Brilliant! Thank you!

[#5]

Hi Sunindia

Sum ({<Jahr={$(VaktJahr)}>} ([Rohertrag_BA]))

Thank you for your help!