Conditional Formatting on Pivot columns

Hi everyone,
Just asking How to set visual format on a Pivot Column

Originally the “Missing in Table 1” is ‘null’
So basically Table 1 count is ‘GREEN’ and Table 2 count is ‘RED’

Cant seems to find conditional format base on a different column.

Also the Fields are currently in this format


hi @edward

If i’m understanding correctly maybe you could do the following.

1- create two calculated fields for each count, potentially using ifelse logic to do the count based on the required dim.
2- change pivot table to ‘rows’ (from the default of ‘columns’
3- add column ‘table 1’ to the rows field well
4- add those two calculated fields as values to the pivot.

Please let me know if this helps!
ramon lopez