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