How to Change Background Color in Pivot Table

[panipat1990]

Dear Team,

i Stuck a requirement. i want to change background color of Second dimension.

in my Table 3 field

Field1

Field2

Field3

I made a pivot table. I used Field 1 and field 2 as a column

and field 3 as Raw level.And Measure is sum(Sale)

In Field2 i have a Value 1,2,3,4,5,6,7,8,

My Requirement is Background of 1 Show Red Color

                                Background of 1 Show Yellow Color

                               Background of 1 Show GreenColor

                               Background of 1 Show OrangeColor

For this i am Sharing Data And Qvw. Kindly Help me for resolving this requirement

[madhumitha]

Hello Gourav,

Please find attached file.

hope this helps

[prma7799]

I you want to change background color on dimension then got to

Properties >> dimension >> select Dimension >> background color >> write condition here

[panipat1990]

i know the way.but Kindly help me for resolving my problem

[ieuyar]

on field2 dimension, use below expression for background color:

=if(match(Field2,1,2,3,4),pick(match(Field2,1,2,3,4),red(),yellow(),green(),ColorMix1(0.5,red(),yellow())),white())

[madhumitha]

What exactly is your issue?

is that not working?

can you share more details??