Color By Expression

[#1]

Hi All,

I have a data modell like this:

    direction values here: in or out

    amount: values here numbers

    date: values here ...

I would like to make an accumulated line chart (succeeded) which represents the incomes and expenses, and colored the two line with an expression  (not succeeded).

Dimension: date

Measures:

     RangeSum(Above(Sum({<direction={'in'}>}amount),0,RowNo())) and

     RangeSum(Above(Sum({<direction={'out'}>}amount),0,RowNo()))

Coloring:

Color and legend / Colors by expression: if(direction='in',lightred(),lightgreen()).

Please help me how can I set up the colors with expression for the lines.

qvf, pic and data are attached.

Thanks,

Daniel