Pivot Table Background color coding

[robin_heijt]

Hi,

I would like to do the following:

IF(VI='% of Internal Moves' and
(Count(distinct{<[Retroactiveness IT00 (New)]={'On Time'},"Action Type ID"={'ZB','ZF'}>}[# IT00])/Count(distinct{<"Action Type ID"={'ZB','ZF'}>}[# IT00]))

>=IF( Country=[Retro Target Country],[% of Internal Moves]),green(),rgb(255, 255, 102))

Where Country=Retro target country uses this file:

Each piece of code individually seems to be working properly in Straight tables and KPI's But when using it to establish the color coding of a pivot table background, It does not seem to work.

Anyone that can give any insights?

Thanks