Dimension values color

[#1]

Hello,

I have a pivot table with two dimensions: "Months" as rows, and "Year" as columns (2012, 2013, 2014). i need the "Year" dimension values, 2013, 2013, 2014 to appear in 3 different backgrounds colors (green, red, blue). Please see below (except that here a changes the text color as opposed to the background color).

Any Ideas?

Thanks

	2012	2013	2014
Jan	$100	$120	$310
Feb	$200	$130	$400
Mar	$300	$140	$490
Apr	$400	$150	$580
May	$500	$160	$670
Jun	$600	$170	$760
Jul	$700	$180	$850
Aug	$800	$190	$940
Sep	$900	$200	$1,030
Oct	$1,000	$210	$1,120
Nov	$1,100	$220	$1,210
Dec	$1,200	$230	$1,300

[Nicole-Smith · Accepted solution]

On your Year dimension, click on the plus sign next to to it, then in Background Color, you can type in an expression like the following:

pick(match(Year, 2012, 2013, 2014), rgb(0,255,0), rgb(255,0,0), rgb(0,0,255))

[#3]

Danny,

In the Expression tab, click on your Expression (there is a +)

You will see different properties.

You can enter the expression for the background. Basically: if(year=2010, red(), if(year=2011, blue()))

You can use also color(), rgb() ....

Fabrice