pivot table dimension background color issue

[ashok1203]

Hi All,

Below is the pivot table that we need create in application based on the attached Source data. For the Field Priority i need to display a background colours based on the field value.

If the value is 1,2 -> red()

3,4 -> yellow()

others-> green()

i tried this through dimension background color if conditions, pick match functions and Custom Format cell colors but not working as excepted. Please help me to achieve the output as expected.

Attached the Qvw file for reference.

[ashok1203]

Thanks Sunny

[ashok1203]

Sunny, I am developing the same kind of reports.For some of the reports i am getting correct output as per your response but still for some of the reports i am getting the output as expected.

[sunny_talwar]

Would you be able to share an example?