Change text or background color in a table

[#1]

Hey guys,

From the table below, I am trying to achieve the following:

I  want  the first highest amount in the Amount column to change to a specific color both the background and the text to say red per customer selection that will be made. But, I don't know how to get that done. Please any help will be truly appreciated.

Year	Month	Invoice-type	Amount	# of invoices
2015	Jan	Advances	€ 500	1
2015	Feb	Advances	€ 500	1
2015	Mar	Advances	€ 500	1
2015	Apr	Advances	€ 500	1
2015	May	Advances	€ 500	1
2015	Jun	Advances	€ 650	1
2015	Jul	Advances	€ 650	1
2015	Aug	Advances	€ 650	1
2015	Sep	Advances	€ 650	1
2015	Oct	Advances	€ 450	1
2015	Nov	Advances	€ 450	1
2015	Dec	Advances	€ 450	1

Thanks in advance,

Simon.

[Clever_Anjos]

Go to "Visual Cues" tab, there you can configure rules to change color using a formula like

MAX( TOTAL Aggr(sum(Amount), Year, Month)))

[#3]

Hey Clever,

Thanks for your reply but I have the amount as a dimension so based on the table I showed, can you help me with the expression I can use to change the colors. I am completely new to this.

Thanks

[Anonymous]

On the Dimension tab you should see a small plus sign to the left of each Used Dimension.  Click the plus sign, click Text Color and add an expression, maybe something like :

     if ( Month = 'Jun' , Red() , Green() )

Then change the expression to what suits your needs.

[Clever_Anjos]

PFA