Pivot column background_colour

[#1]

I am using Pivot table with 3 dimension and 3 measures in which 1 Dimension is pivoted. Need to show the multiple background color for pivoted dimension. 

In the above attachment Year is highlighted with multicolor for example.

[daveamz]

Hi,

Use in "Background Color" the following expression:

pick(match(Year,2008,2009,2010), rgb(255,255,0), rgb(255,167,122), rgb(175,165,255))

Regards,

David

[#3]

Dear David,

Thanks for your immediate response.

In our case year is dynamical value.  We can't strict to mention the value of the year.