Help required for Pivot color coding

[piyush_s11]

Hi,

I have a pivot table in which different entities are there. For each entity I have to apply a fixed color code.

I have applied color code however it only applies to last column.

Please find attached screenshot for reference.

In above screenshot, you may find that, only for March month the color code is applying. I want the color code must be applied to all the month. 

Also in Description section Retain & scrap I want to apply the same color code.

Please find attached qvw file for reference.

Kindly provide the solution.

Thanks in advance.

[tresesco · Accepted solution]

You have to use set analysis in background expression to ignore selections. Use expression like:

=Only({1}if(FieldID='400',RGB(0,255,0),if(FieldID='413',RGB(255,0,0),
if(FieldID='588',RGB(255,255,0),))))

[avinashelite · Accepted solution]

This is because of  the expression you have written and the single select option that you have enabled .....

you need to tweak the expression to make this work