6 Replies Latest reply: Jan 29, 2016 2:58 PM by Guilherme Radiske

# how to paint entire row based on last month value?

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

I have this table

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?

• ###### Re: how to paint entire row based on last month value?

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.

• ###### Re: how to paint entire row based on last month value?

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.

• ###### Re: how to paint entire row based on last month value?

Hi ,

In Your second Expression-> Back Gorund Colour ->

Mention Your complete Expression at Both Fields

HTH,

Hirish

• ###### Re: how to paint entire row based on last month value?

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.

• ###### Re: how to paint entire row based on last month value?

Hi,

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

• ###### Re: how to paint entire row based on last month value?

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.