how to paint entire row based on last month value?

[gradiske]

Guys, i'm having trouble to do something i think its simple but i can't reach the solution

I have this table

The red ones are based on if(Realizado>Orçado) then Red.

What i need to do is, paint the entire row in red if the last month of the selections, in this case, december, if the last month is red, the entire row should be red.

Any ideas?

[Gysbert_Wassenaar]

You can apply the same color condition to all the expressions. Click on the + in front of the expression, choose Background Color and enter your color expression. You won't be apply to apply it to your first dimension since that cell spans lots of rows.

[gradiske]

The same color condition is already set in all expressions, the problem is, if one month not correponds to the logic (Realizado>Orçado) it will not paint in red. I want to ignore the currentmonth and only consider the last possible one.

[HirisH_V7]

Hi ,

In Your second Expression-> Back Gorund Colour ->

=If(Realizado>Orçado,LightRed())

Mention Your complete Expression at Both Fields

HTH,

Hirish

[gradiske]

=If(Realizado>Orçado,rgb(255,94,94))

I've tried this too much that i posted the wrong print, heres what it looks like.

If you look at A-2 or A-3, for example, in December(Competencia dez/2015) Realizado>Orçado=False, so, the entire row should remain blue(the default color).

X-6, X-7 and A-1 are entire filled with red because every single month returns Realizado>Orçado=True. I want to paint everything based on the last possible month only.

I know that =If(Realizado>Orçado,rgb(255,94,94)) never will achieve that requirement, but i've tried all sort of set analysis possible.

The expressions at Realizado and Orçado are simple: Sum(field)

[HirisH_V7]

Hi,

Do you want to red line particularly for 7th Line or what ?

[gradiske]

Hi,

I want red line on the rows that the last month(competencia) returns True to Realizado>Orçado.

In the picture, we have Oct, Nov and Dec. It doesnt matter if Oct and Nov returns False, if the value at Dec returns True, all the values in the row should be painted red.