Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
.
I think you should sort for date numerically asc first.
your expression looks good.
.
did you solve it?
.
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() )