Background Color in Pivot table not always work.

[#1]

Hello,

I have a pivot table and Color Code column there which background should be same as text in the field...

I have implemented it this way:

=IF(ColorCode='Green',RGB(171,255,199),

IF(ColorCode='Orange',RGB(255,231,132),

IF(ColorCode='Red',RGB(255,186,165),

IF(ColorCode='Blue',RGB(148,205,249),

RGB(255,255,255)

))))

But, strangely, there are fields which are not colored:

(attached image)

EDIT:

I have now added qvw file for better explanation.

Thanks for all advice!

[fdelacal]

add. TRIM,,, may be is that you have space

=

IF(TRIM(ColorCode)='Green',RGB(171,255,199),

IF(TRIM(ColorCode)='Orange',RGB(255,231,132),

IF(TRIM(ColorCode)='Red',RGB(255,186,165),

IF(TRIM(ColorCode)='Blue',RGB(148,205,249),

RGB(255,255,255)

))))

HOPE THAT SOLVE YOUR PROBLEM, if not, can you add a qvw. example?

Regards

[Sokkorn]

Hi Kuba,

Not sure you try this one yet

=IF(WildMatch(ColorCode,'*Green*'),RGB(171,255,199),

IF(WildMatch(ColorCode,'*Orange*'),RGB(255,231,132),

IF(WildMatch(ColorCode,'*Red*'),RGB(255,186,165),

IF(WildMatch(ColorCode,'*Blue*'),RGB(148,205,249),

RGB(255,255,255)

))))

Regards,

Sokkorn

[#4]

Thank you both for fast reply, ColorCode has only 4 values so this is not (unfortunetly) connected to data mismatch.

I will try to prepare some qvw.

BR,

Kuba

[#5]

I have now added qvw example.

[fdelacal]

the problem is the pibot date!

see atach.

[#7]

I understnad that, but client wants to see it presented as in initial file... Is there any workaround for that?

This seems like a QV bug.

[#8]

I will bump it, maybe someone else will propose other solution...

[#9]

Hi Kuba,

Please find the attached file hope this will helps.

Regards,

Nirmal

[#10]

Hello,

Thank you for reply but it deos not work. I must divide htis data by date, So when I will move date it is still not working properly...

Attaching your file with change I need.

BR,

Kuba