?

[xyz1]

.

[xyz1]

.

[agigliotti]

I think you should sort for date numerically asc first.

[agigliotti]

your expression looks good.

[xyz1]

.

[agigliotti]

did you solve it?

[xyz1]

.

[agigliotti]

maybe this:

=if(

Sum(

Aggr( AVG( {$< market={'DOMESTIC'}, [date.Calendar.MonthRelNo]={'0'}, [date.Calendar.Year]={'2018'}, im_descr-={'*SCRAP*'}, im_descr_limited_flag = {1} >} rate ), rate )

)

>

Sum(

Aggr( AVG( { $< market={'DOMESTIC'}, [date.Calendar.MonthRelNo]={'1'}, [date.Calendar.Year]={'2018'}, im_descr-={'*SCRAP*'}, im_descr_limited_flag = {1} >} rate ), rate )

)

, LightRed(), Green() )

and set Sorting by Month numerically ASC.

Otherwise simplest for color expression :

if( After( column(2) ) > column(2), RGB(201, 17, 62), green() )